How to rename table name into alternative name in sql server 2005

Posted by Kirubakaranb.Tech under Sql Server on 1/22/2013 | Points: 10 | Views : 4324 | Status : [Member] | Replies : 3

I try this two coding but not work properly

Rename the login table to newlogin

ALTER TABLE login RENAME TO newlogin

reply correct answer.

Reply | Reply with Attachment

Posted by: Kundan64 on: 1/22/2013 [Member] Starter | Points: 25

0	SP_RENAME login, newlogin above query will give Caution: Changing any part of an object name could break scripts and stored procedures. but your table name will be changed. Mark as Answer if it helps you. Kirubakaranb.Tech, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Prashikudupi on: 1/23/2013 [Member] Starter | Points: 25

0	In addition to above reply, SP_RENAME can also be used to rename a column name of an object. EXEC SP_RENAME 'TABLE.OLD_COL ', 'NEW_COL ','COLUMN' Kirubakaranb.Tech, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Pavanandey on: 1/23/2013 [Member] Bronze | Points: 25

0	The script for renaming any column : sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN' The script for renaming any object (table, sp etc) : sp_RENAME '[OldTableName]' , '[NewTableName]' Mark answer if this helps you Thanks Pavan Kumar Mark Answer if this fits the need Kirubakaranb.Tech, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts