2
Reply

What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table?

Rohatash Kumar

Rohatash Kumar

13y
5.5k
0
Reply

    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.

    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.