drop--> means table is delete ,not roll back, truncate-->

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

Question Posted / ramavtar rajput

Answer Posted / ramavtar rajput

drop--> means table is delete ,not roll back,

truncate-->

Is This Answer Correct ?

18 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What is data in mysql?

896

What is a string in mysql?

889

How to create trigger in mysql workbench?

983

What is mysql data directory? How to determine the location of the data directory?

928

How does mysql store data?

929

How do you concatenate strings in mysql?

999

How to create a new table by selecting rows from another table in mysql?

978

What is session variable in mysql?

970

Does adding an index lock a table?

954

What are the non-standard sql commands supported by 'mysql'?

981

What is mysql uuid?

923

How do I check mysql version?

1031

How to see table's field formats or description of table .

879

How do I find the size of a mysql database?

909

What is database engine in mysql?

930