How to Change a Table Name in SQL

Last updated Thursday, June/13/2019

1). Log in to a database that uses SQL.
2). Type the command "alter table TABLE_01 rename to TABLE_10;" to rename the "TABLE_01" table to "TABLE_10."
3). Type the statement "show tables;" to show the tables in the database and make sure the table has been renamed correctly.
4). Type the command "quit" to exit the database.

Source...

MSDN Microsoft Windows Exchange server Office Visual Studio Outlook Solutions Excel win XP NT 2003 technology Microsoft Access Excel ffice Powerpoint Word Oracle

ISCL is a Intelligent Information Consulting System. Based on our knowledgebase, using AI tools such as CHATGPT, Customers could customize the information according to their needs, So as to achieve