Machine-translated by Google. Questions are authored in English.
Top

Discussion

After a table has been created, its structure can be modified using the SQL command:

  • A.UPDATE TABLE [TableName].
  • B.MODIFY TABLE [TableName].
  • C.ALTER TABLE [TableName].
  • D.CHANGE TABLE [TableName].

Answer: C

Correct answer: ALTER TABLE [ TableName ].

ALTER TABLE is the standard command for changing an existing table - adding or dropping a column, changing a datatype, adding or removing a constraint. UPDATE changes data rather than structure, and the other two are not SQL commands at all.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.