How to change table name using SQL query?

Question

How can I change the table name using a query statement?

I used the following syntax but could not find the rename keyword in SQL Server 2005.

Alter table Stu_Table rename to Stu_Table_10 

Answer 1

Use sp_rename:

 EXEC sp_rename 'Stu_Table', 'Stu_Table_10' 

You can find the documentation for this procedure on MSDN .

If you need to include a schema name, this can only be included in the first parameter (that is, it cannot be used to move a table from one schema to another). So, for example, this is valid:

 EXEC sp_rename 'myschema.Stu_Table', 'Stu_Table_10' 

Answer 2

In MySQL : -

 RENAME TABLE `Stu Table` TO `Stu Table_10` 

Answer 3

Please use this on SQL Server 2005:

 sp_rename old_table_name , new_table_name 

he will give you:

Warning: changing any part of the object name can lead to breakdown of scripts and stored procedures.

but the name of your table will be changed.

Answer 4

In Postgress SQL:

 Alter table student rename to student_details; 

Answer 5

In MySQL:

Rename the template_function table TO business_function ;

Answer 6

 RENAME TABLE old_table_name TO new_table_name; 

Answer 7

The syntax for the latest versions of MySQL has been changed.

So, try to run the RENAME command without SINGLE QUOTES in the table names.

RENAME TABLE old_name_of_table TO new_name_of_table;

Answer 8

ALTER TABLE table_name RENAME TO new_table_name; also works in MySQL.

Alternatively: RENAME TABLE table_name TO new_table_name ;

Answer 9

execute this command

 sp_rename 'Employee','EData'