How to Remove a Column from a Table in SQL

Jack, a database developer wants to remove a column from the existing table he created. Which of the following SQL commands can be used to remove the column from the table?

A. Create B. use C. alter D. drop

Answer:

The correct answer is 'alter'.

The ALTER TABLE command in SQL is used to modify the structure of an existing table. You can use the ALTER TABLE command to add, remove, or modify columns in a table.

Example:

To remove a column named 'column_name' from a table named 'table_name', you would use the following SQL statement:

ALTER TABLE table_name DROP COLUMN column_name;

Note:

• The DROP COLUMN clause is used to remove a column from a table.
• Make sure to replace table_name and column_name with the actual names of your table and column.
• The DROP COLUMN clause will permanently delete the column and its data from the table.