SQL Server ->> 存储过程sp_rename重命名数据对象

 

 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