- SQL Basics
- SQL Introduction
- SQL Syntax
- SQL Sample Database
- SQL SELECT
- SQL WHERE
- SQL ORDER BY
- SQL DISTINCT
- SQL LIMIT
- SQL FETCH
- SQL AND
- SQL OR
- SQL BETWEEN
- SQL IN
- SQL LIKE
- SQL IS NULL
- SQL Comparison Operators
- SQL Logical Operators
- SQL Alias
- SQL CASE
- Joins and Subqueries
- SQL INNER JOIN
- SQL LEFT JOIN
- SQL RIGHT JOIN
- SQL FULL OUTER JOIN
- SQL SELF JOIN
- SQL CROSS JOIN
- SQL Subquery
- SQL Correlated Subquery
- SQL UNION
- SQL INTERSECT
- SQL EXCEPT
- Aggregate Functions
- SQL AVG
- SQL COUNT
- SQL MAX
- SQL MIN
- SQL SUM
- SQL GROUP BY
- SQL HAVING
- SQL ROLLUP
- SQL CUBE
- SQL GROUPING SETS
- Database Management
- SQL CREATE DATABASE
- SQL ALTER DATABASE
- SQL DROP DATABASE
- SQL BACKUP DATABASE
- SQL SHOW DATABASES
- SQL SELECT DATABASE
- Table Management
- SQL CREATE TABLE
- SQL ALTER TABLE
- SQL ADD COLUMN
- SQL DROP COLUMN
- SQL DROP TABLE
- SQL TRUNCATE TABLE
- SQL SHOW TABLES
- SQL RENAME TABLE
- SQL Constraints
- SQL Primary Key
- SQL Foreign Key
- SQL UNIQUE Constraint
- SQL CHECK Constraint
- SQL NOT NULL Constraint
SQL RENAME TABLE
The RENAME TABLE statement is used to change the name of an existing table.
Key Features of SQL RENAME TABLE
- Allows renaming one or multiple tables in a database.
- Ensures all table data, indexes, and constraints remain intact.
- Works in MySQL, MariaDB, and some other databases.
SQL RENAME TABLE Syntax
RENAME TABLE old_table_name TO new_table_name;
Example: Renaming a Table
RENAME TABLE Employees TO Staff;
- Renames the
Employeestable toStaff.
Example: Renaming Multiple Tables
RENAME TABLE Orders TO CustomerOrders, Products TO Inventory;
- Changes
OrderstoCustomerOrdersandProductstoInventory.
Alternative Commands for Other Databases
Summary
RENAME TABLEis used to rename tables in MySQL/MariaDB.- Other databases use
ALTER TABLE ... RENAME TO .... - All table data and constraints remain unchanged.