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.0k views
in Computer by (95 points)
edited by

What is the purpose of DROP TABLE command in MySql?how is it different fromDELETE command.

Please log in or register to answer this question.

1 Answer

+1 vote
by (50.0k points)

MYSQL uses a Drop Table statement to delete the existing table. This statement removes the complete data of a table along with the whole structure or definition permanently from the database. So, you must be very careful while removing the table because we cannot recover the lost data after deleting it.

DELETE is a Data Manipulation Language command, DML command and is used to remove tuples/records from a relation/table. Whereas DROP is a Data Definition Language, DDL command and is used to remove named elements of schema like relations/table, constraints or entire schema.

Related questions

+1 vote
1 answer
+2 votes
1 answer
asked Apr 3, 2023 in English by Chinmayapradhan (21.9k points)
+2 votes
1 answer
asked Mar 11, 2023 in English by Chinmayapradhan (21.9k points)
+2 votes
1 answer
asked Mar 11, 2023 in English by Chinmayapradhan (21.9k points)

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

...