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

What is meant by mysqli?

840

Can we store pdf files in mysql?

914

What is the maximum size of table in mysql?

955

How to get help information from the server?

980

Is mysql good for large database?

855

What is a data directory?

873

What causes mysql too many connections?

872

What are all the Common SQL Function?

1046

What is the role of a limit in a mysql query?

945

What is username in mysql?

844

What are the technical specifications of mysql?

1088

How can you move the master database

1968

How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

950

How do I drop a database in mysql?

1064

How to return query output in xml format?

980