How do i rename the table name using SQL query?

Question

I Used the following syntax but I couldn't find the rename keyword in SQL server 2005.

Alter table Stu_Table rename to Stu_Table_10

Please help me in renaming the table name using a query statement.

Answer 1

Use sp_rename:

EXEC sp_rename 'Stu_Table', 'Stu_Table_10'

You can find documentation on this procedure on MSDN.

Answer 2

RENAME TABLE Stu_Table TO Stu_Table_10

Answer 3

hi

Please use this on sql server2005

sp_rename old_table_name , new_table_name

it will give you "Caution: Changing any part of an object name could break scripts and stored procedures." but your table name willbe changed