in Technology 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
    What are the TRUNCATE, DELETE and DROP statements?...
asked Dec 9, 2020 in Technology by JackTerrance
0 votes
    What is the difference between DELETE and TRUNCATE statements?...
asked Dec 11, 2020 by JackTerrance
0 votes
    So in my project, I have a model Chat with many Messages. I want to have ChatSerializer with ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 20, 2022 in Education by JackTerrance
0 votes
    Which of the following statements is wrong about today's world? (1) The relationship between different countries has ... of the above. Select the correct answer from above options...
asked Aug 3, 2022 in Education by JackTerrance
0 votes
    Is it possible to create drop down filter?...
asked Nov 21, 2020 in Technology by JackTerrance
0 votes
0 votes
0 votes
    Does a parameter have its own drop-down list?...
asked Oct 30, 2020 in Technology by JackTerrance
0 votes
    I'm maintaining a Windows app that has multiple forms in the one window (form1, form2, form3). I' ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 26, 2022 in Education by JackTerrance
0 votes
    Which of the following code drop the ith and jth column? (a) new...
asked Feb 12, 2022 in Education by JackTerrance
0 votes
    To open the table, on the icon that has the required table name in Tables Pane of Database Window (A) Drag ... click (D) Triple Click Select the correct answer from above options...
asked Dec 24, 2021 in Education by JackTerrance
0 votes
    Which of the following are the drag and drop events? (a) drop (b) dragstart (c) both drop and ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Oct 22, 2021 in Education by JackTerrance
0 votes
    I added a table that I thought I was going to need, but now no longer plan on using it. How ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jun 10, 2022 in Education by JackTerrance
0 votes
    I have this page, the superfish menu does not show over the google earth plugin but under! This problem ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 28, 2022 in Education by JackTerrance
0 votes
    How can I use Ext.tree.ViewDDPlugin's events? I have a TreePanel that uses DDPplugin, but I'd ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 17, 2022 in Education by JackTerrance
...