How to change a table name using an SQL query

Question

How can I in change the table name using a query statement   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

User · Answer

In MySQL    RENAME TABLE template function TO business function

User · Answer

In MySQL  -  RENAME TABLE  Stu Table  TO  Stu Table 10

User · Answer

RENAME TABLE old table name TO new table name

User · Answer

Use sp rename   EXEC sp rename  Stu Table    Stu Table 10    You can find documentation on this procedure on MSDN   If you need to include a schema name  this can only be included in the first parameter  that is  this 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

User · Answer

execute this command  sp rename  Employee   EData

User · Answer

In Postgress SQL   Alter table student rename to student details

User · Answer

Please use this on SQL Server 2005   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 will be changed

User · Answer

ALTER TABLE table name RENAME TO new table name  works in MySQL as well     Alternatively  RENAME TABLE table name TO new table name

User · Answer

rename table name    RENAME TABLE old tableName TO new tableName    for example   RENAME TABLE company name TO company master

User · Answer

Syntex for latest MySQL versions has been changed   So try RENAME command without SINGLE QUOTES in table names   RENAME TABLE old name of table TO new name of table

[sql] How to change a table name using an SQL query?

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2005