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

What are the different data types in mysql?

925

What is triggers?

959

How to convert character strings to numeric values?

1127

How we get sum of column.

1008

How do I disable mysql?

935

How do I run mysql from command line?

1041

What is normalization and list the different types of normalization?

946

What is delimiter in mysql?

872

What is a mysql server?

981

How do you connect MySQL database with PHP?

982

How do you know if your mysql server is alive?

1075

What are the 3 main types of search queries?

837

How does mysql clustering work?

919

What is the difference between having and where clause in mysql? Explain

1018

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

1006