How to rename or change table name in sql?

Questions by shojol

Showing Answers 1 - 18 of 18 Answers

Vaibhav

  • Apr 2nd, 2012
 

Code
  1. ALTER TABLE table_name

    2. 

  2. RENAME TO new_table_name;

    3. 

  3. Example:-

    4. 

  4. ALTER TABLE departments

    5. 

  5. RENAME TO dept ;

    6. 

  6.  

ravinder

  • May 4th, 2012
 

alter table table_name_old rename to table_name_new;

  Was this answer useful?  Yes

shikha

  • Feb 3rd, 2013
 

sp_RENAME old_table_name, new_table_name

  Was this answer useful?  Yes

Neeru Nagi

  • May 20th, 2015
 

In Sql_Server,
SP_RENAME old_table_name, new_table_name

  Was this answer useful?  Yes

Avanish Kumar

  • May 26th, 2015
 

rename table old_tablename to new_tablename

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions