5 years ago in Database Management System

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

[A] MODIFY TABLE TableName DROP COLUMN ColumnName
[B] MODIFY TABLE TableName DROP ColumnName
[C] ALTER TABLE TableName DROP COLUMN ColumnName
[D] ALTER TABLE TableName DROP ColumnName
Loading...
Next Question

Overall Stats

Attempted 268
Correct 67
Incorrect 70
Viewed 131

Answers

Guest
Guest
Shamsa hafeez
Shamsa hafeez - 3 days ago

Shamsa hafeez from Lahore, Pakistan is saying ALTER TABLE TableName DROP ColumnName is correct answer

Tsega Asresa Mengistu
Tsega Asresa Mengistu - 5 days ago

Tsega Asresa Mengistu from Dessie, Ethiopia is saying ALTER TABLE TableName DROP COLUMN ColumnName is correct answer

Serkie Mekonnen
Serkie Mekonnen - 5 days ago

Serkie Mekonnen from Dessie, Ethiopia is saying ALTER TABLE TableName DROP COLUMN ColumnName is correct answer

sureshbabu vampugadapa
sureshbabu vampugadapa - 1 month ago

sureshbabu vampugadapa from Guntur, India is saying MODIFY TABLE TableName DROP ColumnName is correct answer

Deep
Deep - 1 month ago

Deep from Kolkata, India is saying ALTER TABLE TableName DROP ColumnName is correct answer

Related Questions

The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?

  • [A] Overlapping rule
  • [B] Disjoint rule
  • [C] Total specialization rule
  • [D] Partial specialization rule

Referential integrity controls relationships between :

  • [A] attributes in a table
  • [B] operations of an object
  • [C] instances of a class
  • [D] tables in a database

Object based data models are used in describing the abstraction of the following levels?

  • [A] Conceptual and view
  • [B] Only physical
  • [C] Physical and conceptual
  • [D] Only conceptual

Which of the following SQL statements are helpful in database redesign?

  • [A] Correlated subqueries only
  • [B] EXISTS/NOT EXISTS expressions only
  • [C] Both of the above are helpful
  • [D] None of the above are helpful.