Article View: borland.public.interbase.sql
Article #192Re: Modify Primary Index
From: Bill Todd [TeamB]
Date: Wed, 06 Aug 2008 03:38
Date: Wed, 06 Aug 2008 03:38
19 lines
1669 bytes
1669 bytes
Ken Pfeiffer wrote: > The problem I am having is that when I attempt > to drop the index with DROP INDEX RDB$PRIMARY143 > I get an error "cannot delete index used by an integrity > constant" and the operation fails. The error means that the primary index is reference by a foreign key constraint. You will have to drop the foreign key constraint and any other constraints that depend on the primary index before you can drop the primary key and recreate it. This is a classic example of why you should use a surrogate key generated by a generator for the primary key. Had you done that then created a separate unique constraint on the multiple data columns adding another column to the unique constraint would be easy. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<48991ccb$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!newshub.sdsu.edu!news.linkpendium.com!news.linkpendium.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<4898c1dd$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,ee6c7f974eb6ad62
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd [TeamB]" <no@no.com>
Subject: Re: Modify Primary Index
Newsgroups: borland.public.interbase.sql
References: <4898c1dd$1@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.9
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 63.147.41.232
Message-ID: <48991ccb$1@newsgroups.borland.com>
Date: 5 Aug 2008 20:38:51 -0700
X-Trace: newsgroups.borland.com 1217993931 63.147.41.232 (5 Aug 2008 20:38:51 -0700)
Lines: 19
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!newshub.sdsu.edu!news.linkpendium.com!news.linkpendium.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail