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 & Solution

Correct Answer: Option D

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.

Question posted by Examveda

Community

Join the Discussion

1 Comment

Join the discussion

Login to post a comment or share your explanation.

Davender Verma 10 years ago

answer depends upon the database are you using oracle or sql

Keep Learning

What SQL command can be used to delete columns from a...

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

Join the Discussion

Related Questions on Sql Miscellaneous