Database - Database Redesign - Discussion

Discussion Forum : Database Redesign - General Questions (Q.No. 2)

Database Redesign

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

MODIFY TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP ColumnName

Answer: Option

Explanation:

No answer description is available. Let's discuss.

Discussion:

2 comments Page 1 of 1.

Umer Shahid said: 5 years ago

Option D is correct because there is no reserved word COLUMN in DB.

Michael said: 7 years ago

I think it is option D.

Post your comments here:

Quick links

Quantitative Aptitude

Verbal (English)

Reasoning

Programming

Interview

Placement Papers