Global Web Forum

husnain

Administrator

From: Chichawatni,Pakistan

Registered: 2014-10-03

Posts: 8,129

Website

SQL Command:

Database Quizzes SQL

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

Option A):
ALTER TABLE TableName DROP COLUMN ColumnName
Option B):
MODIFY TABLE TableName DROP COLUMN ColumnName
Option C):
MODIFY TABLE TableName DROP ColumnName

Correct Answer is Option A):
ALTER TABLE TableName DROP COLUMN ColumnName

---

You cannot discover the new oceans unless you have the courage to lose the sight of the shore.