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

1 Answer

0 votes
by

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 Jul 7, 2020 in Sql by Robindeniel
...