The SQL ALTER TABLE statement is used to:
2018
The SQL ALTER TABLE statement is used to:
- A.
Add, delete, or modify columns in an existing table
- B.
Drop an existing table in a database
- C.
Insert or modify records in a table
- D.
Delete existing records in a table
Attempted by 343 students.
Show answer & explanation
Correct answer: A
The SQL ALTER TABLE command is used to modify the structure of an existing database table. It allows users to add, delete, or modify columns within that specific table schema without affecting the data itself. Other commands like DROP TABLE remove the entire table, while INSERT and UPDATE handle data manipulation rather than structural changes.