Examveda
Examveda

What SQL command can be used to delete columns from a table?

A. MODIFY TABLE TableName DROP ColumnName

B. MODIFY TABLE TableName DROP COLUMN ColumnName

C. ALTER TABLE TableName DROP ColumnName

D. ALTER TABLE TableName DROP COLUMN ColumnName

Answer: Option D

Solution(By Examveda Team)

To delete columns from a table in SQL, you can use the ALTER TABLE TableName DROP COLUMN ColumnName command. Option D is the correct choice for removing columns from a table. Options A, B, and C do not represent the standard SQL syntax for deleting columns.

This Question Belongs to SQL >> Sql Miscellaneous

Join The Discussion

Comments ( 1 )

  1. Davender Verma
    Davender Verma :
    7 years ago

    answer depends upon the database are you using oracle or sql

Related Questions on Sql Miscellaneous