SQL ALTER TABLE
The ALTER TABLE command is used to add, modify or delete columns in an existing table. It is also used to rename a table.
SQL ALTER TABLE Add Column Syntax
ALTER TABLE table_name ADD column_name column-definition;
SQL ALTER TABLE Modify Column Syntax
ALTER TABLE table_name MODIFY column_name column_type;
SQL ALTER TABLE DROP Column Syntax
ALTER TABLE table_name DROP COLUMN column_name;
SQL ALTER TABLE RENAME Column Syntax
ALTER TABLE table_name
RENAME COLUMN old_name to new_name;
ALTER TABLE table_name ADD column_name column-definition;
SQL ALTER TABLE Modify Column Syntax
ALTER TABLE table_name MODIFY column_name column_type;
SQL ALTER TABLE DROP Column Syntax
ALTER TABLE table_name DROP COLUMN column_name;
SQL ALTER TABLE RENAME Column Syntax
ALTER TABLE table_name
RENAME COLUMN old_name to new_name;
ALTER TABLE table_name MODIFY column_name column_type;
SQL ALTER TABLE DROP Column Syntax
ALTER TABLE table_name DROP COLUMN column_name;
SQL ALTER TABLE RENAME Column Syntax
ALTER TABLE table_name
RENAME COLUMN old_name to new_name;
ALTER TABLE table_name DROP COLUMN column_name;
SQL ALTER TABLE RENAME Column Syntax
ALTER TABLE table_name
RENAME COLUMN old_name to new_name;
ALTER TABLE table_name RENAME COLUMN old_name to new_name;