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
2.5k views
in Computer by (72.4k points)

Differentiate between DELETE and DROP table commands ?

1 Answer

+1 vote
by (89.4k points)
selected by
 
Best answer

DELETE command is used to remove infor¬mation from a particular row or rows. If used without condition, it will delete all row information but not the structure of the table. It is a DML command. 

DROP table command is used to remove the entire structure of the table and information. It is a DDL command

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

...