How to Rename table name in sql server?
hi can anyone tell me the query How to Rename table name in sql server.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Nilesh AvhadPosted May 19, 2014, 7:22 AM
SP_RENAME 'EXIST TABLE NAME ','NEW TABLE NAME'
E.G.
SP_RENAME 'EMP','EMPLOYEE'
Anupam SinghPosted May 19, 2014, 5:54 AM
Try :
sp_rename 'OLD_TABLE_NAME','NEW_TABLE_NAME'