Hi,
Delete Command with where CLAUSE will delete specified records,
but Delete Command without where CLAUSE will delete all rows from the table.
For Ex:
DELETE FROM Table Where <Condition>;
DELETE FROM Table;
If u want to delete all the datas permanently from the table use TRUNCATE Command.
May be this helps u in the
Difference between DELETE and TRUNCATE commands.
Did u mean the Bulk Delete insense of deleting all rows from the table?