Drop a Table : Delete over all table is called drop... Truncate a table

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

Question Posted / raabhu

Answer Posted / raabhu

Drop a Table : Delete over all table is called drop...

Truncate a table : Delete only the field names of table is
called truncate...

Is This Answer Correct ?

6 Yes

12 No

Please Help Members By Posting Answers For Below Questions

Where is mysql used?

1032

Is mysql port 3306 tcp or udp?

964

What are the functions in mysql?

1005

Is mysql from oracle?

1010

Where’s database data actually stored?

1006

What is myisamchk?

1022

What is the size of mysql database?

982

What is the default password for mysql?

942

What are the different types of triggers in mysql?

1014

Can't connect mysql server on localhost?

1117

What is the difference between unix timestamp and mysql timestamp?

1093

What is ibdata1?

961

How do I update a variable in mysql?

983

What is mysql connector used for?

990

Can you tell which of the following where clauses is faster?

991