Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Drop all foreign keys in a db

2 posts in General Discussion Last posting was on 2004-02-09 12:14:04.0Z
Nob Posted on 2004-02-09 02:26:38.0Z
Sender: 211b.4026ef1a.1804289383@sybase.com
From: Nob
Newsgroups: ianywhere.public.general
Subject: Drop all foreign keys in a db
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <4026efde.211e.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Feb 2004 18:26:38 -0800
X-Trace: forums-1-dub 1076293598 10.22.241.41 (8 Feb 2004 18:26:38 -0800)
X-Original-Trace: 8 Feb 2004 18:26:38 -0800, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2452
Article PK: 5587

I am using ASA 8.0.2.4215

Is there an easy way to drop all foreign keys in a given db?

Or at least make the db ignore all foreign keys during the
running of a script?


Breck Carter [TeamSybase] Posted on 2004-02-09 12:14:04.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Drop all foreign keys in a db
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <99te20d589f7n714vv5t6gv7dil02s2v8h@4ax.com>
References: <4026efde.211e.846930886@sybase.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 9 Feb 2004 04:24:52 -0800, bcarter.sentex.ca
Lines: 17
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Feb 2004 03:56:19 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Feb 2004 04:14:04 -0800
X-Trace: forums-1-dub 1076328844 10.22.108.75 (9 Feb 2004 04:14:04 -0800)
X-Original-Trace: 9 Feb 2004 04:14:04 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2453
Article PK: 5590

Have a look at the WAIT_FOR_COMMIT option.

Breck

On 8 Feb 2004 18:26:38 -0800, Nob wrote:

>I am using ASA 8.0.2.4215
>
>Is there an easy way to drop all foreign keys in a given db?
>
>Or at least make the db ignore all foreign keys during the
>running of a script?

--
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com