Question

The command used to delete a particular column in a relation is

Answer 1

Answer:

The command used to delete a particular column in a relation is Alter table command.

Answer 2

The command used to delete a specific column in a relation is Alter table command.

Explanation:  

The ALTER TABLE command is a type of “Data Definition Language” (DDL) command. DDLs are commands that:

• Define the database schema.  
• Create, modify the structure of objects in the database.  
• The CREATE, DROP and ALTER commands are DDL commands created in SQL statements.
• Using ALTER TABLE, The columns of the existing table can be added, deleted, or modified.
• We can add or drop constraints defined on the existing table.