1) 表转移Schema和重命名表
ALTER SCHEMA Stage TRANSFER dbo.Stage_AAA; EXEC sp_rename 'Stage.Stage_AAA', 'AAA';
2)重命名列
USE [MyDB] GO IF EXISTS(SELECT * FROM sys.columns WHERE name = N'Column' AND object_id = object_id('[dbo].[Table]')) BEGIN EXEC sp_rename '[dbo].[Table].[Column]', 'Column1', 'COLUMN' END