> ALTER TABLE NOTIFICATIONS ADD CONSTRAINT FK_NOTIFICATIONS_STOCK FOREIGN KEY > (FK_STOCK_ID) REFERENCES STOCKS (STOCK_ID)
>Is this the correct syntax? >i think it should look like >ALTER TABLE NOTIFICATIONS ADD FOREIGN KEY >FK_NOTIFICATIONS_STOCK (FK_STOCK_ID) REFERENCES STOCKS (STOCK_ID) Thanks for your response. The syntax you stated works fine. Now I have a very interesting problem. The code I provided originally was generated, and I believe it should be ANSI-compliant. Though, neither of the options ate it, only oracle. And there seems to be no easy way to switch to Oracle mode for all queries. Or is it? I'm still browsing the tons of docs, and cannot say I'm comfortable with it. And I will try to bug the app server vendor. __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
