What is the Difference in DROP, DELETE and TRUNCATE command in SQL Server ?

Total Post:87

Points:617
 637  View(s)
Ratings:
Rate this:

when should we used Drop, Delete, and Truncate command in SQL server?

  1. Post:286

    Points:2044
    Re: What is the Difference in DROP, DELETE and TRUNCATE command in SQL Server ?

    Truncate:- This is the part of DDL command in SQL. when we use the truncate command on a table then deleted all records and rows from that table and release space that's used by the table in database memory.

    Delete:- when we use the DeleteCommand in SQL server on a table without any condition then all rows and data will be deleted from that table but the structure will not be removed. It means memory space will be not free. It means in delete case the memory space will be not free.

    DROP:- When we used DROP command on a table, then the rows and records in the table are deleted and the table structure is also removed from the database. Once a table is dropped we cannot get it back, so be careful while using the DROP command. When a table is dropped all the references to the table will not be valid.

Answer

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.