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:.. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
