In this page we are going to discuss about the usage of SQL ALTER TABLE statement to add and drop CHECK CONSTRAINT of column(s) of a table.

In this page we are going to discuss about the usage of SQL ALTER TABLE statement to add and drop foreign key of a table.

In this page we are going to discuss about the usage of SQL ALTER TABLE statement to add and drop primary key of a table.

In this page we are going to discuss about the usage of SQL ALTER TABLE statement is used to add a constraint for a column and also drop an existing constraint of a column from a table if the column exists in the table.

In this page we are going to discuss how to drop the default value of a column from a table if the column exists in the table using SQL ALTER TABLE statement.

In this page we are discussing, how a column can be dropped from a table if it exists in the table, using the SQL ALTER TABLE statement.

The SQL ALTER TABLE command is used to change the structure of an existing table.

MySQL DROP VIEW command is used to drop a view. A view is a temporary storage of a table.

If MySQL ALETR command is used with DROP following the table column name, that column will be deleted from the table.

MySQL DROP INDEX command removes an index from a table.