delete all from table

sql mysql ms-access optimization performance

Alex Gordon · Jun 8, 2010 · Viewed 228.8k times · Source

what's faster?

DELETE FROM table_name;

DELETE FROM table_name where 1=1;

why?

does truncate table work in access?

Answer

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