Loading
What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table?
2 Answers
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.
Rahul PrajapatPosted May 30, 2015, 10:04 AM
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.
MAHESH MALLEPALLYPosted Mar 21, 2011, 3:32 AM