http://www.sqlservercentral.com/blogs/vivekssqlnotes/2012/01/02/how-to-remane-a-table-in-sql-server/
Printed 2013/05/25 02:25AM
How to remane a Table in Sql Server
2012/01/02
To rename a column in a SQL Table following command can be reused:
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.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.
