in Sql by
What is the difference between DROP and TRUNCATE statements?

1 Answer

0 votes

If a table is dropped, all things associated with the tables are dropped as well. This includes - the relationships defined on the table with other tables, the integrity checks and constraints, access privileges and other grants that the table has. To create and use the table again in its original form, all these relations, checks, constraints, privileges and relationships need to be redefined. However, if a table is truncated, none of the above problems exist and the table retains its original structure.

Related questions

0 votes
asked Jul 7, 2020 in Sql by Robindeniel
0 votes
asked Jun 15, 2021 in QlikView by sharadyadav1986
0 votes
asked Nov 8, 2021 in Sql by rajeshsharma