DBMS | SQL | Question 2

Which of the following command is used to delete a table in SQL?
(A) delete
(B) truncate
(C) remove
(D) drop

Answer: (D)
Explanation: drop is used to delete a table completely
Quiz of this Question

Article Tags :

DBMS Quiz

Recommended Articles

1. Configure SQL Jobs in SQL Server using T-SQL

2. DBMS | SQL | Question 1

3. Difference between DBMS and SQL

4. Difference between SQL and T-SQL

5. SQL Server | Convert tables in T-SQL into XML

6. Fragmentation in Distributed DBMS

7. Difference between Assertions and Triggers in DBMS

8. Difference Between DDL and DML in DBMS

9. Query Processing in Distributed DBMS

10. Difference Between Dense Index and Sparse Index in DBMS

11. Difference Between ON DELETE CASCADE and ON DELETE SET NULL in DBMS

12. Intro to SQL Server | Architecture

13. QUOTENAME() Function in SQL Server

14. Delete statement in MS SQL Server

15. SQL Indexes

16. How to Create a Table With a Foreign Key in SQL?

17. REVERSE() Function in SQL Server

18. ISNULL() Function in SQL Server

19. Check whether a Table exists in SQL Server database or not

20. SQL | Query Processing

21. SQL Snapshots

23. SQL Trigger | Book Management Database

24. SQL Query to Get Yesterday and Tomorrow

25. Reverse Statement Word by Word in SQL server