Re: Deleting all data from tables

From: Dave Abercrombie <abe_at_rahul.net>
Date: 10 Sep 1999 00:17:48 GMT
Message-ID: <7r9inc$j91$1@samba.rahul.net>

In article <7r8rnh$nvc$1_at_nnrp1.deja.com>, Alex <albu_at_my-deja.com> wrote:
{ What's the best way to delete all data from a user's tables, while
{ keeping the table structure? Simply running DELETE FROM <table_name> for
{ all tables will not work because of a myriad of integrity constraints
{ without the ON DELETE CASCADE...

How about doing a ROWS=N export, dropping the user, recreating the user, them importing.

Dave Abercrombie          (510) 653-1204          122 15.23' W
abe_at_rahul.net                                      37 50.97' N

Received on Thu Sep 09 1999 - 19:17:48 CDT