Computer Science
Answer
ALTER
Reason — DDL (Data Definition Language) commands in SQL are used to create and define tables and other database objects. Examples of DDL commands include ALTER, which is used to modify objects like tables, indexes, views, and constraints. On the other hand, SELECT, INSERT, and UPDATE commands are part of DML (Data Manipulation Language), used for retrieving, inserting, and updating data within the database.
Related Questions
The …………… clause allows sorting of query results by one or more columns.
- ALL
- DISTINCT
- GROUP BY
- ORDER BY
Which clause is used in query to place the condition on groups in MySQL?
- WHERE
- HAVING
- GROUP BY
- Both (i) & (ii)
Which of the following types of table constraints will prevent the entry of duplicate rows?
- Unique
- Distinct
- Primary Key
- NULL
…………… command is used to remove primary key from a table in SQL.
- Update
- Remove
- Alter
- Drop