PDA

Click to See Complete Forum and Search --> : Purging tables


Apr 24th, 2000, 11:36 AM
Is anyone aware of any commands for purging of a table in an access database? That is, I would like to delete all the data in it but not the structure. I am at the moment working between two tables and constantly need to clear data in them. So what I am doing now is killing the table and recreating them again. Surely there must be a way of purging the data without having to recreate the whole table. If anyone has any suggestions, I would greatly appreciate it.

Thank you.
Ben
benni@sydney.cbr.com.au

msdnexpert
Apr 24th, 2000, 12:00 PM
A simple SQL statement will do the job man.
"Delete from "+tablename.
That's it.

Apr 24th, 2000, 12:33 PM
Thanks for that. I'm not actually too experienced with SQL and was looking in MSDN for help, but nothing like that came up. Only found how to kill a table.

Thanks again.