Which SQL keyword is used to change the structure,properties or constraints of a table?
A)SET
B)CREATE
C)SELECT
D)ALTER
E)CONSTRAINT

Question

Quizplus · Accepted Answer

The ALTER keyword is used to modify a table's structure, properties or constraints. It allows the user to add or delete columns, change data types, rename a table or column, and modify constraints of a table. SET is used to update or change the value of an existing column. CREATE is used to create a new table or database object. SELECT is used to retrieve data from a table or tables. CONSTRAINT is used to set rules or limits on the data that can be entered into a table.

Which SQL Keyword Is Used to Change the Structure,properties or Constraints