mssql alter table 的用法

alter table 没有 alter constraint 属性，所以只能是先drop constraint, 再add constraint.

alter table [table_name] drop constraint [constraint_name]

alter table [table_name] add constraint [constraint_name] [constraint_content]

alter table [table_name] add column [column_name] [column_type]

alter table [table_name] add constraint [constraint_name] default [default value] for [column]

alter table [table Name] drop column [column name]

alter table [table Name ]add [column name] int identity(1,1) not null.

DBCC CHECKIDENT (【table name】, RESEED, 1)

alter   table   table_name     drop   constraint   pk_name

alter   table   table_name   add   constraint   pk_name   primary   key   (column name)

ALTER TABLE 【table name 】
ADD CONSTRAINT [constraint name] FOREIGN KEY ([column name])
    REFERENCES [reference table ] (reference column name ) ;
ALTER TABLE [table name ]
DROP CONSTRAINT [refence constraint name] ;

sp_rename [ @objname = ] 'object_name' , [ @newname = ] 'new_name' 
    [ , [ @objtype = ] 'object_type' ] 

exec sp_rename 'dbo.tblTable.a', 'b', 'COLUMN'