To rename a column in a SQL Table following command can be reused:
SP_RENAME ‘old table name’, ‘New table name’
SP_RENAME ‘old table name’, ‘New table name’
For example, if we want to rename the table from employee to employeemaster, following command can be used.
SP_RENAME ’employee’, ’employeemaster’
This command will rename the table from employee to employeemaster.
Discover more from Technology with Vivek Johari
Subscribe to get the latest posts sent to your email.
Nice one…
I think its Rename instead of remane in title—–"How to remane a Table in Sql Server" 🙂
Thanks again..:-)
Corrected