Which command is used to add a column/integrity constraint to a table in SQL?
2017
Which command is used to add a column/integrity constraint to a table in SQL?
- A.
Alter Table
- B.
Insert Column
- C.
Modify Table
- D.
All of these
Attempted by 124 students.
Show answer & explanation
Correct answer: A
The correct answer is A (Alter Table). In SQL, the ALTER TABLE statement is a Data Definition Language (DDL) command used to modify the structure of an existing table. It allows you to add, delete, or modify columns, as well as add or drop various integrity constraints.