delete all from table

Question

what's faster?

DELETE FROM table_name; 

or

DELETE FROM table_name where 1=1; 

why?

does truncate table work in access?

Answer 1

This should be faster:

DELETE * FROM table_name; 

because RDBMS don't have to look where is what.

You should be fine with truncate though:

truncate table table_name 

Answer 2

You can use the below query to remove all the rows from the table, also you should keep it in mind that it will reset the Identity too.

TRUNCATE TABLE table_name