Re: Deleting all data from tables

From: Christian Rodemeyer <c.rodemeyer_at_dr-staedtler.de>
Date: Mon, 13 Sep 1999 10:45:53 +0200
Message-ID: <7ri9qc$53e$1@news.ecrc.de>

Try 'TRUNCATE TABLE <table_name>'. It drops all data without recovery and checks.

Christian Rodemeyer

Dave Abercrombie schrieb in Nachricht <7r9inc$j91$1_at_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 Mon Sep 13 1999 - 03:45:53 CDT