sys.sp_rename

用toad for sql server 之后发现

可用下面这段代码去rename一个存储过程

-- Renamed to viewfocus.dbo.P_DSS_SynrDeviceData_old_1

USE [viewfocus];
GO
EXEC sys.sp_rename @objname = N'[dbo].[P_DSS_SynrDeviceData_old]', @newname = N'P_DSS_SynrDeviceData_old_1', @objtype = N'OBJECT';
GO