Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 33 of 79

Table Creation and Data Manipulation Commands — Question 7

Back to all questions
7
Question

Question 7

In SQL, which command(s) is(are) used to change a table's structure / characteristics ?

  1. ALTER TABLE
  2. MODIFY TABLE
  3. CHANGE TABLE
  4. All of these
Answer

ALTER TABLE

Reason — The ALTER TABLE command in SQL is used to change the definitions of existing tables. It allows for various operations such as adding a new column, redefining a column, and adding an integrity constraint. Therefore, it changes the structure of the table.