Eric, To find the table(s) with foreign key(s) referencing your table, you can do a LIST CONSTRAINT command, and look in the column entitled "References" for your table name. Then look one column to the left to find the table name with an FK referencing your table.
I would say first, RENAME the column in the other table that has a name you want to use in this table. Then use ALTER TABLE ... DROP CONSTRAINT ... to drop any FKs refering to the table on which you are about to perform surgery. Don't forget to look through your application files for any references to the columns that you are renaming. Bill On Thu, 6 Dec 2001 13:59:22 -0600, Eric Peterson wrote: >I was assuming that I couldn't drop this table because I had this >'parlance' (that must be french for limitation). When I try to drop >the table the error is 'This table is referenced by a Foreign Key'. >Which I now found which column has a foreign key referenced against it, >but don't know what table is referencing it (how do I find this?). > >What I have is a multi level problem. I can't drop the table because >there's a foreign key, of which I have no idea which table is linked. >Secondly, I cannot just go and ALTER the table because there's another >table in the DB that contains a column name that I want to use in this >table. > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l
