SQL ALTER TABLE query is used to add, modify, or delete columns in the existing table. The ALTER TABLE query is also used to add and drop various constraints on a current table. ALTER TABLE statement in SQL is used to add, modify, or drop columns in a table. You can also use an ALTER TABLE command to add and drop various constraints on an existing table.

SQL ALTER TABLE Statement Example

SQL ALTER TABLE modifies the table definition by altering, adding, or dropping columns and constraints. ALTER TABLE also reassigns and rebuilds the partitions, or disables and enables the constraints and  triggers.

Once a table is created in the database, there are many occasions where one may wish to change the structure of the table.

#sql #sql alter table #alter table