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.
Nice one…
I think its Rename instead of remane in title—–"How to remane a Table in Sql Server" 🙂
Thanks again..:-)
Corrected