Stack Overflow
Stack Overflow

Questions tagged [table-rename]

Table renaming is an option in SQL used to rename tables. It is a part of DDL (Data Definition Language).

Table renaming is an option in SQL used to rename tables. It is a part of DDL (Data Definition Language).

Renaming a table can be done in various ways:

RENAME old_table_name TO new_table_name

works only in the same schema while

ALTER TABLE schema.old_table_name RENAME TO new_table_name

can be used on tables in other schemas.

47 questions
-3
votes
1 answer

Need a VBA code. rename sheets from list

Need a VBA code. rename sheets from list I have a list of names in sheet 2 cell w3 thru w22. I need to name sheets/tabs 3 thur 22 from the the list of names. The names change. and if no name in w3 thru w22. I want the tabs to be numbered 1 thru…
Thayne Greene
  • 1
  • 1
-3
votes
3 answers

MySQL - Renaming table named "TABLE 12"

I'm trying to pass my problem... namely I can't rename my table named "TABLE 12" which was imported. I got a response: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax…
mayilook
  • 7
  • 1
  • 4
1 2 3
4