I have a need to remove a Foreign Key in an command file but have been unable to discern the proper syntax.
Help file says: ALTER TABLE tablename DROP CONSTRAINT conname But I can not figure out exactly what conname is. I thought it was Constraint Name which (as far as I can tell) can not be defined as part of the constraint but is assigned a number name by the system. The number assigned, in the form "#nn", can seen in the Table Definitions form and can also be found in the Sys_Indexes table in the Sys_Index_Name column, so I tried: ALTER TABLE tablename DROP CONSTRAINT #45 ALTER TABLE tablename DROP CONSTRAINT "#45" ALTER TABLE tablename DROP CONSTRAINT 45 I also tired: ALTER TABLE tablename DROP CONSTRAINT FOREIGN KEY ALTER TABLE tablename DROP CONSTRAINT FOREIGN KEY (columnname) ... and others but no matter what I try to use I get an -ERROR- Invalid constraint identifier. (2743) error message. Once again, I am sure it is simple but I can't find it... Can anyone point me in the right direction? Thanks! Michael Moser EXAQ Micro Services www.exaq.com Phone: 916-768-7656 Fax: 916-966-8313
