Computer Science
Which command is used for removing a table and all its data from the database :
- Create table command
- Drop table command
- Alter table command
- All of these
DDL & DML
3 Likes
Answer
Drop table command
Reason — The DROP TABLE command is used to delete a table and all its data from the database. Once this command is given, the table name is no longer recognized and no more commands can be given on the object.
Answered By
3 Likes
Related Questions
Fill in the blank :
…………… command is used to remove primary key from a table in SQL.
- update
- remove
- alter
- drop
Which command defines its columns, integrity constraint in create table :
- Create table command
- Drop table command
- Alter table command
- All of these
Which of the following is not a DDL command ?
- UPDATE
- TRUNCATE
- ALTER
- None of these
Which of the following is not a legal constraint for a CREATE TABLE command ?
- Primary key
- Foreign key
- Unique
- Distinct