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]
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]
posted on