Computer Science
Which of the following commands will delete the table from MYSQL database ?
- DELETE TABLE
- DROP TABLE
- REMOVE TABLE
- ALTER TABLE
DDL & DML
1 Like
Answer
DROP TABLE
Reason — The DROP TABLE command in SQL will delete the table from the MYSQL database. Once this command is executed, the table and all its associated data are removed from the database. After dropping the table, the table name is no longer recognized within the database system, and no further commands can be executed on that object.
Answered By
1 Like
Related Questions
Which of the following is/are the DDL statements ?
- Create
- Drop
- Alter
- All of these
In SQL, which command(s) is(are) used to change a table's structure / characteristics ?
- ALTER TABLE
- MODIFY TABLE
- CHANGE TABLE
- All of these
…………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
- Column
- Constraint
- Index
- Trigger
Fill in the blank :
…………… command is used to remove primary key from a table in SQL.
- update
- remove
- alter
- drop