Multiple choice

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

  1. UPDATE TABLE [TableName].

  2. MODIFY TABLE [TableName].

  3. ALTER TABLE [TableName].

  4. CHANGE TABLE [TableName].
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ALTER TABLE is the standard SQL command for modifying the structure of an existing table. This includes adding, dropping, or modifying columns, constraints, and other table properties. UPDATE TABLE is used for modifying data within a table, not its structure. MODIFY TABLE and CHANGE TABLE are not valid SQL commands in any major database system.

Keep practicing — related questions