Drop - will Delete the table date as well as the table structure. Truncat

What are the differences between drop a table and truncate
a table?

Question Posted / velmurugan

Answer Posted / velmurugan

Drop - will Delete the table date as well as the table
structure.
Truncate - Will Delete the table data only. The table
structure will remains.

Is This Answer Correct ?

71 Yes

9 No

Please Help Members By Posting Answers For Below Questions

How to check if value already exists in mysql database in php?

931

Is there a way to see the files which are stored?

1010

What is a transaction? Describe mysql transaction properties.

1158

What does "i_am_a_dummy flag" do in mysql?

994

Is mysqli secure?

937

What is slow query log in mysql?

1155

What is the date format in mysql?

941

What port is mysql running on?

979

What are the steps involved in query processing?

937

How to change the database engine in mysql?

1067

How do I automate a backup in mysql?

1043

What is difference between function and procedure in mysql?

1009

Why we use mongodb instead of mysql?

1016

What is a join in mysql?

954

How to convert character strings to numeric values?

1174