> -----Original Message----- > From: Gerd K�nig [mailto:[EMAIL PROTECTED] > 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/[EMAIL PROTECTED]
