Question

Which of the following SQL statement is used to delete a column from a table ___________________.

• A. DELETE column-name from table name
• B. ALTER TABLE table name DROP COLUMN column name
• C. DROP column name FROM table name
• D. None of the above

Answer 1

The correct option is B ALTER TABLE table name DROP COLUMN column name

SQL statement is used to delete a column from a table.

ALTER TABLE table name DROP COLUMN column name.

ALTER TABLE statement to add a column, modify a column, drop a column, rename a column or rename a table.

The ALTER TABLE statement is also used to add and drop various constraints on an existing table.

Structured query language uses a collection of imperative verbs whose effect is to modify the schema of the database by adding, changing, or deleting definitions of tables or other elements.