Welcome to Questionaries, where you can ask questions and receive answers from other members of the community.

Let us know at info@questionaries.org

Differences between DROP a table and TRUNCATE a table?

3 like 0 dislike
What are the differences between DROP a table and TRUNCATE a table?
asked 1 year ago by daneim (127,080 points)

1 Answer

1 like 0 dislike
 
Best answer
DROP TABLE table_name - This will delete the table and its data.

TRUNCATE TABLE table_name - This will delete the data of the table, but not the table definition.
answered 1 year ago by marck_don (191,010 points)

Related questions

5 like 0 dislike
1 answer
7 like 0 dislike
1 answer
9 like 0 dislike
1 answer