Need support for your remote team? Check out our new promo!*
*Limited-time offer applies to the first charge of a new subscription only.
10 licenses for the price of 3
40 licenses for the price of 10
CREATE PROC rename_sp (@TableName nvarchar(100)) AS
Declare @sql nvarchar(1000)
@sql = 'EXEC sp_RENAME ''' + @TableName + '.[UID]'== + ' , ''' + @TableName _UID + ''', '''COLUMN'
-- Run this a couple of times and eyeball to make sure it works.
Open in new window
CREATE PROCEDURE MySp_rename @OldName VARCHAR(128), @NewName VARCHAR(128)
EXEC sp_rename @OldName, @NewName, 'COLUMN'
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.
Take hold of your future.