ALTER TABLE RENAME

ALTER TABLE RENAME is a SQL statement in the DDL Statements category. Renames a table. Note: PostgreSQL uses separate RENAME TO syntax, MySQL uses RENAME TABLE. The syntax is ALTER TABLE old_name RENAME TO new_name;. It returns renamed object. A typical example: -- Standard: ALTER TABLE employees RENAME TO staff; -- MySQL: RENAME TABLE employees TO staff; -- PostgreSQL: ALTER TABLE employees RENAME TO staff; -- Rename a column: ALTER TABLE employees RENAME COLUMN emp_id TO employee_id; -- Rename a database: -- PostgreSQL: ALTER DATABASE old_name RENAME TO new_name; -- MySQL: no direct rename (dump and reload) -- SQL Server: ALTER DATABASE old MODIFY NAME = new; A close relative is CREATE TABLE, which creates a new table in the database with specified columns, data types, and constraints. A close relative is ALTER TABLE, which modifies an existing table: add/drop columns, modify data types, rename, add/drop constraints.