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

1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2490

what is constraints? Also explain the different types of constraints?

953

What is trigger in mysql with example?

907

Does mysql use sql?

875

How many rows can be inserted in mysql at a time?

1002

What is blob and clob?

943

What are the functions used to encrypt and decrypt the data present in mysql?

1088

How to enter Characters as HEX Numbers?

1005

Is mysql is a programming language?

978

How to enable or disable a row of a table using MySQL in struts?

4087

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

908

Is mysql a scripting language?

883

What is prepare statement in mysql?

979

change column name and make a unique column so we get no dupes.

976

How do I find mysql location?

964