Which of the following SQL commands is used to modify the structure of a table?
2023
Which of the following SQL commands is used to modify the structure of a table?
Answer: A. Alter — The SQL command used to modify the structure of a table is ALTER. This command allows you to add, delete, or modify columns, constraints, or indexes in an…
- A.
Alter
- B.
Modify
- C.
Update
- D.
More than one of the above
- E.
None of the above
Attempted by 2172 students.
Show answer & explanation
Correct answer: A
The SQL command used to modify the structure of a table is ALTER. This command allows you to add, delete, or modify columns, constraints, or indexes in an existing table. For example, ALTER TABLE table_name ADD column_name datatype; adds a new column. It is the standard command for structural changes in SQL.
Loading lesson…