MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which command is used for removing a table and all its data from the database:
A
Create command
B
Drop table command
C
Alter table command
D
All of the mentioned
Explanation: 

Detailed explanation-1: -The DROP TABLE statement is used to drop an existing table in a database.

Detailed explanation-2: -We use the SQL DROP Table command to drop a table from the database. It completely removes the table structure and associated indexes, statistics, permissions, triggers and constraints.

Detailed explanation-3: -Explanation: The TRUNCATE statement in SQL removes all data from the table and free the table’s space.

There is 1 question to complete.
Previous
Next