how to rename a tablename in sql server

Question

Sanjeeb Lenka · Answer

you can use this query EXECUTE sp_rename 'oldTableName'  'newTableName' EXECUTE sp_rename 'tb1'  'tb2' or you can follow the link given by Riyaz

Pankaj Pandey · Answer

use databasename sp_RENAME '[OldTableName]'  '[NewTableName]'

Riyaz Akhtar · Answer

Check out the below link PINAL DAVE has nicely explained how to rename table and coulmn name: http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/