Re: Delete data from all user tables

Article View: borland.public.interbase.sql

Article #439

Back to borland.public.interbase.sql Previous Next

#439

From: Quinn Wildman (CodeGear Develope...
Date: Mon, 17 Mar 2008 18:51

17 lines
1759 bytes

If you want to delete all data, the end result is just meta data. Why 
not just extract the meta data? Here's how to do it with isql:

isql -x yourdatabase -o somefile.ext -u user -pass password

Adalberto Baldini wrote:
> I want to delete all data of a company from all tables in DB.
> As foreign keys relate each other I had tried to set feature OnDelete 
> cascade, starting delete from Table Company.
> It doesn't work because the order delete processes tables conflicts with 
> foreign keys integrity.
> 
> There is any suggestion how to do it other than I create mydelete 
> sequence manually and maintain it in order ?
> 
> Thanks
> Adalberto Baldini

Technical Details

Message-ID: <47debdda$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!eweka.nl!lightspeed.eweka.nl!195.114.231.69.MISMATCH!feeder.news-service.com!news2.euro.net!newsfeed.freenet.de!news.osn.de!diablo1.news.osn.de!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <47de28be$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,129e16198f438d12
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Mon, 17 Mar 2008 11:51:35 -0700
From: "Quinn Wildman (CodeGear Developer Support)" <qwildman@nospam.codegear.com>
User-Agent: Thunderbird 1.5.0.14 (Windows/20071210)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: Delete data from all user tables
References: <47de28be$1@newsgroups.borland.com>
In-Reply-To: <47de28be$1@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.143.100.209
Message-ID: <47debdda$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1205779930 10.143.100.209 (17 Mar 2008 11:52:10 -0700)
Lines: 17
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!eweka.nl!lightspeed.eweka.nl!195.114.231.69.MISMATCH!feeder.news-service.com!news2.euro.net!newsfeed.freenet.de!news.osn.de!diablo1.news.osn.de!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message