<

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;
















© copyright 2017-2022 Completedone pvt ltd.