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
… [Trackback]
[…] Find More on to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Read More on on that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Find More to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Read More Info here to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Info to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Find More on to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Information to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Read More on to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Info on that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Read More Information here on that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] There you will find 18492 more Information to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Read More to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Here you can find 49828 additional Info to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Here you will find 96228 more Info on that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Find More to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Info to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Find More here on that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Information on that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Info to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Info to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Find More on that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Read More to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Read More Information here to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Read More to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Information on that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Read More Information here on that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Read More on that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Read More Info here on that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Find More on on that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]
… [Trackback]
[…] Here you will find 43729 more Information to that Topic: techmixing.com/2012/01/how-to-remane-table-in-sql-server.html […]