Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
+1 vote
4.0k views
in Computer by (79.0k points)

What are the differences between DELETE and DROP commands of SQL?

1 Answer

+2 votes
by (76.3k points)
selected by
 
Best answer
DELETE DROP
(i) DML command (i) DDL command
(ii) Deletes the content of the table. (ii) Deletes the contents and the true of the table.
(iii) DELETE FROM <tablename> WHERE <condition>. (iii) DROP TABLE<Tablename>

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...