Rohatash Kumar
What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table?
By Rohatash Kumar in SQL on Mar 15 2011
  • Rahul Prajapat
    May, 2015 30

    DROPPING A TABLE means this command is used to drop the table structure from database.This command is imlicitly commit will be called.We no need to call explicitly commit.TRUNCATING A TABLE means this command is used to delete the bulk data at atime.But table structure is available.In this command also we no need to call explicitly commit, automatically implicitly commit will be call.DELETING ALL RECCORDS means this command is used to delete all records from table.In this command we have to call explicitly commit.In case of delete bulk data this command is not good performens.

    • 0
  • MAHESH MALLEPALLY
    Mar, 2011 21

    DROPPING A TABLE means this command is used to drop the table structure from database.This command is imlicitly commit will be called.We no need to call explicitly commit.

    TRUNCATING A TABLE means this command is used to delete the bulk data at atime.But table structure is available.In this command also we no need to call explicitly commit, automatically implicitly commit will be call.

    DELETING ALL RECCORDS means this command is used to delete all records from table.In this command we have to call explicitly commit.In case of delete bulk data this command is not good performens.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS