Delete data from all user tables

Article View: borland.public.interbase.sql

Article #436

Back to borland.public.interbase.sql Previous Next

#436

From: Adalberto Baldini
Date: Mon, 17 Mar 2008 08:16

11 lines
1380 bytes

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: <47de28be$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,129e16198f438d12,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Mon, 17 Mar 2008 09:16:03 +0100
From: Adalberto Baldini <finman@swissonline.ch>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Delete data from all user tables
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 080316-0, 16/03/2008), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 83.77.175.115
Message-ID: <47de28be$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1205741758 83.77.175.115 (17 Mar 2008 01:15:58 -0700)
Lines: 11
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail