chang sqlserver column name

EXECUTE sp_rename N'dbo.yy.a5', N'Tmp_a8', 'COLUMN'
EXECUTE sp_rename N'dbo.yy.Tmp_a8', N'a8', 'COLUMN'

change sqlserver table name

EXEC sp_rename N'[dbo].[Test_Old]', N'Test_New', N'object'

add default value
ALTER TABLE ParaPrintAuto ADD CONSTRAINT DF_ParaPrintAuto_F_Year DEFAULT ('1') FOR [F_Year]

转载于:https://www.cnblogs.com/gamebaby/archive/2006/03/26/359449.html