Access/SQL Database - Purge SQL tables to import fresh data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a quick way to purge the SQL data? Doing a delete from the Access
front end is slow and painful. Do I go into Enterprise Manager and drop the
table?
Help please
 
JimMurray said:
Is there a quick way to purge the SQL data? Doing a delete from the
Access front end is slow and painful. Do I go into Enterprise Manager
and drop the table?
Help please
Click to expand...

Use a passthrough query and use...

truncate table TableName

....instead of a delete statement. The latter is a logged update whereas
truncate is not and should be virtually instantaneous.
 
Use a pass-through query instead. "Delete from tablename" will do the
trick. If you're OK with a non-logged operation, use the T-SQL
"Truncate table" command, which is even faster.

--Mary
 
Back
Top