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 DDL command for modifying the structure of an existing table. This command can be used to add, drop, or rename columns, change column data types, add or drop constraints, and modify other table properties. The UPDATE command modifies data within a table, not its structure. MODIFY, CHANGE, and other variations are not valid SQL commands for table structure modification - only ALTER TABLE is the correct syntax.

Keep practicing — related questions