Computer Science
In SQL, which command(s) is(are) used to change a table's structure / characteristics ?
- ALTER TABLE
- MODIFY TABLE
- CHANGE TABLE
- All of these
DDL & DML
1 Like
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.
Answered By
2 Likes
Related Questions
In the given query which keyword has to be inserted ?
INSERT INTO employee ............... (1002, Kausar, 2000) ;- Table
- Values
- Relation
- Field
Which of the following is/are the DDL statements ?
- Create
- Drop
- Alter
- All of these
Which of the following commands will delete the table from MYSQL database ?
- DELETE TABLE
- DROP TABLE
- REMOVE TABLE
- ALTER TABLE
…………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
- Column
- Constraint
- Index
- Trigger