Rename table MySQL

mysql Share on :

RENAME TABLE statement is used to change that the name of a single table or multiple tables.

-- SINGLE TABLE
RENAME TABLE courses TO subjects;

-- MULTIPLE TABLES
RENAME TABLE 
    courses TO subjects,
    topics TO subject_topics;

In the code snippet, we are renaming or changing the name of a table from 'courses' to 'subjects'. We can also change multiple table names with a single query.

Search Index Data (The code snippet can also be found with below search text)

Change table name MySQL

Contribute to this Snippet

Was this helpful?

Created by :

@

Write your Comment

0 Comments

Similar code snippets

Create table with constraints MySQL query
Insert data into table mysql query
Add foreign key in existing table Mysql
Remove or drop table MySQL
Delete a column from Table MySQL
Show all column names of a table MySql query
Get table information in MySQL

Create your own code snippets and search them using our portal and chrome extension

Programming Feeds

Learn something new everyday on Devsheet

Important Links

Join Devsheet Create new snippet Ask a Question Write an article Online JSON Viewer

Find us at: