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
… [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 […]