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

all the queries used in sql

2585

How to make a column bigger and delete unique from table.

882

How do I run mysql from command line?

973

Explain Access Control Lists.

929

How to concatenate two character strings?

967

What is row level locking?

868

How do I create a database in mysql workbench?

821

What are the different mysql database engines?

1055

How to returns the columns and column information pertaining to the designated table.

972

What is the maximum number of columns per table?

869

What is the purpose of -> in the mysql terminal?

1034

What is pragma exception?

906

What are stored procedures and functions?

855

How to use case expression?

896

What is a simple query?

839