RE: remove primary key which is foreign key in diff. table

> -----Original Message-----
> From: Gerd König [mailto:koenig@xxxxxxxxxxxxxxx]
> Sent: Montag, 24. November 2003 10:09
> To: SAPDB Mailinglist
> Subject: remove primary key which is foreign key in diff. table
> 
> 
> Hi,
> 
> I want to remove a primary key (for creating a new one with 
> one additional
> column).
> This column references (foreign key) a column in a different table,
> so I think I first have to remove this referential constraint 
> and then drop
> the
> primary key, right ?
> 
> My problem is that I don't know the constraint name of this 
> foreign key.
> Where can I get this information from, so that I can build my sql:
> 
> 1.) alter table tab1 drop foreign key <constraint-name>
> 2.) alter table tab1 drop primary key
> 3.) alter table tab1 add primary key(...,...)
> 
> thanks in advance ..:GERD:..

In this case a check of the system tables (available in the online-docs)
would have helped and shown that there is a table called foreignkeys.
Please see:
http://www.sapdb.org/7.4/htmhelp/2a/30bb8170e5d346a9decb7932cfe7f7/frameset.htm

Elke
SAP Labs Berlin

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx