Question

How to Use SP_rename store Procedure?

Answer

CREATE TABLE Rename_Test ( ID INT IDENTITY(1, 1) PRIMARY KEY , varName VARCHAR(100) )

Step 1 Change the table Name with SP_rename Store procedure

Syntax :EXEC SP_rename 'Old Table Name','New Table Name'

EXEC SPrename 'RenameTest','RenameTestNew'

SELECT * FROM Rename_Test

SELECT * FROM RenameTestnew

Step 2 Change the Column Name with SP_rename Store procedure

Syntax :EXEC SP_rename 'Table Name.Column','New Column Name','Column'

EXEC SPrename 'RenameTest_New.varName','varFullName','Column'

SELECT * FROM RenameTestnew

Step 3 Renaming an index

EXEC sprename N'RenameTestNew.IXOldID', N'IXNewID', N'INDEX';

Read More..   [0 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  ·