ASP.NET Forum

**faisalzafar** · 12-12-2005, 03:37 AM

Hi dear,

I have one application in ASP with Access database and i want to empty the database, can i do that ??

Regards
Faisal Zafar

**chrishirst** · 12-12-2005, 04:24 AM

empty the entire db or empty the tables ?

**faisalzafar** · 12-12-2005, 09:08 AM

any one ? i want the tables and also empty the database , can u plz define both ways
Regrads

**chrishirst** · 12-12-2005, 11:07 AM

you can't empty the database but keep the tables, emptying the database would remove all the tables

I'll assume you want to keep the tables and the db structures intact but just remove the records.

To remove all records from a table you use;

Code:

TRUNCATE TABLE table_name

this will also set any autonumbers back to the initial value

you can also use

Code:

DELETE FROM table_name

to empty the database use;

Code:

DROP TABLE table_name