How to Change a Table Name in SQL

Structured Query Language (SQL) is a database language used with relational databases such as Oracle or MySQL. It comprises statements, queries and clauses, expressions and predicates, which when used together allow the database user to create tables and manipulate the data within those tables. One such statement is the "alter table" statement. This statement makes it possible to change a table name or alter a column within a table.

Instructions

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.