Hello all, I just joined the list and this is my first post, greetings!
I have just started using SapDB with our product which is supposed to run on many different database systems. Oracle supports the syntax ALTER TABLE TNAME ADD CONSTRAINT CNAME FOREIGN KEY(FNAME) REFERENCES TNAME2(FNAME2) Many other databases like SQLServer, MySQL, Access (ahem) and McKoi support the same syntax. I noticed SapDB uses a slightly different syntax. I have some standard scripts for database creation where different database backends require only different column type specifications. My constraint definitions where always identical among the databases we use. I hoped turning on Oracle compatibility mode whould make SapDB eat my constraint definitions but that was not the case. Am I doing something wrong here? Regards, Silvio Bierman _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
