Hi Thomas, Strangely enough i can create a foreign key constraint in SQLMODE ORACLE using regular oracle syntax. ALTER TABLE <tablename> ADD CONSTRAINT <cname> FOREIGN KEY(<columnname>) REFERENCES <tablename>(<columnname>) ON DELETE CASCADE i am curious as to why the droping does not work? Is this delibrate or will support be added at a later stage?(I assume some way of droping fk constraints is necessary)
Also is it advisable to use different MODEs to access the same table (simultaeously or otherwise)? Note:i create tables in oracle mode. regards, Ajit -----Original Message----- From: Anhaus, Thomas [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 3:26 PM To: '[EMAIL PROTECTED]' Cc: ajit_cus Subject: RE:dropping foreign key in oracle mode Ajit wrote : >How do i drop a foreign key in SQLMODE ORACLE? >alter table <tablename> drop constraint <Referential constraint> >says invalid constraint name >the internal syntax of drop foreign key does not work in sqlmode oracle Sorry, but you can't drop a foreign key in oracle mode. You have to switch to SAPDB mode and drop the foreign key using the following syntax : ALTER TABLE <tablename> DROP FOREIGN KEY <constraint name> Regards, Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
