how to rename the table

Question Posted / rabinmeher

3 Answers
6023 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to rename the table..

Answer / rajkumar

SP_RENAME 'OLDTABLE NAME', 'NEW TABLE NAME'
eg:
SP_RENAME 'TBL_EMPLOYEE', 'TBL_EMP'

Is This Answer Correct ?

11 Yes

3 No

how to rename the table..

Answer / vishal

Rename a table using sp_rename

sp_rename <Old Table Name>, <New Column Name>

Rename a column using sp_rename
here as third argument we have to provide column. default
third argument for sp_rename is table.

sp_rename <table name>.<old Column Name>, <New Column Name>,
'column'

Is This Answer Correct ?

2 Yes

0 No

how to rename the table..

Answer / mohan

Rename a table
This example renames the customers table to custs.

EXEC sp_rename 'customers', 'custs'

B. Rename a column
This example renames the contact title column in the
customers table to title.

EXEC sp_rename 'customers.contacttitle', 'title', 'COLUMN'

Is This Answer Correct ?

0 Yes

2 No

Post New Answer