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
