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
answer depends upon the database are you using oracle or sql