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

1.	What is the purpose of DROP TABLE command in MySql?how is it different fromDELETE command.
Answer» 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.

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

Answer»

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.

Discussion

No Comment Found

Related InterviewSolutions

Fill in the blanks. 1. Data is ______ information.2. World’s first general purpose computer is ______ 3. Information is ______ data. 4. Fifth generation computer had ______ intelligence. 5. ______ is the device that uses Index number.
Mention the two types of softwares.
Mention any two output devices
Give any two examples of operating software.
Name any four input devices.
Write a short note on Data.
Who are the pioneers/forerunners of a computer?
What is a computer?
Which of the following is another form of computer?a. Blackboard b. Mobile c. Radio d. Book
Who is the father of Computer? (a) Martin Luther King (b) Graham Bell (c) Charlie Chaplin (d) Charles Babbage