mssql2008中怎样修改列字段名

使用脚本修改吧，界面也可以

脚本如下：

Alter table [表名] Alter column [列名] [列类型] [NOT NULL或者 NULL]

alter table 脚本很丰富，可以查看MS SQL的帮助，新手做baidu任务，给个满意吧

ALTER TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name

{

ALTER COLUMN column_name

{

[ type_schema_name. ] type_name [ ( { precision [ , scale ]

| max | xml_schema_collection } ) ]

[ COLLATE collation_name ]

[ NULL | NOT NULL ]

| {ADD | DROP }

{ ROWGUIDCOL | PERSISTED | NOT FOR REPLICATION | SPARSE }

}

| [ WITH { CHECK | NOCHECK } ]

| ADD

{

<column_definition>

| <computed_column_definition>

| <table_constraint>

| <column_set_definition>

} [ ,...n ]

| DROP

{

[ CONSTRAINT ] constraint_name

[ WITH ( <drop_clustered_constraint_option>[ ,...n ] ) ]

| COLUMN column_name

} [ ,...n ]

| [ WITH { CHECK | NOCHECK } ] { CHECK | NOCHECK } CONSTRAINT

{ ALL | constraint_name [ ,...n ] }

| { ENABLE | DISABLE } TRIGGER

{ ALL | trigger_name [ ,...n ] }

| { ENABLE | DISABLE } CHANGE_TRACKING

[ WITH ( TRACK_COLUMNS_UPDATED = { ON | OFF } ) ]

| SWITCH [ PARTITION source_partition_number_expression ]

TO target_table

[ PARTITION target_partition_number_expression ]

| SET ( FILESTREAM_ON = { partition_scheme_name | filegroup |

"default" | "NULL" } )

| REBUILD

[ [PARTITION = ALL]

[ WITH ( <rebuild_option>[ ,...n ] ) ]

| [ PARTITION = partition_number

[ WITH ( <single_partition_rebuild_option>[ ,...n ] ) ]

]

]

| (<table_option>)

}

[ ]

<column_set_definition>::=

column_set_name XML COLUMN_SET FOR ALL_SPARSE_COLUMNS

<drop_clustered_constraint_option>::=

{

MAXDOP = max_degree_of_parallelism

| ONLINE = {ON | OFF }

| MOVE TO { partition_scheme_name ( column_name ) | filegroup

| "default" }

}

<table_option>::=

{

SET ( LOCK_ESCALATION = { AUTO | TABLE | DISABLE } )

}

<single_partition_rebuild__option>::=

{

SORT_IN_TEMPDB = { ON | OFF }

| MAXDOP = max_degree_of_parallelism

| DATA_COMPRESSION = { NONE | ROW | PAGE} }

}

alter table 学生 add column 入学日期 date, add column 毕业日期 date, add column 备注 varchar(200)

然后你 select * from 学生 limit 1

你就能看到加过之后的结果了。

---