Thanks Hermann, I have committed support for ALTER TABLE <tablename> FOREIGN KEY .. syntax to CVS.
Fred ----- Original Message ----- From: "Hermann Kienlein" <[EMAIL PROTECTED]> To: "fredt" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: 12 April 2003 19:22 Subject: Re: [Hsqldb-developers] New Hi fredt, fredt wrote: > Hi all, > > Extended DatabaseMetaData support is now in CVS. Please check this out and > do some experiments with the return values expected for various boolean > methods and let us know exactly what needs changing. first try I think: really *great great* work. I be begeistert ( sorry to know know the right word in english). > @Fredt: > whats about to set supportsIntegrityEnhancementFacility() to true? > because with this OOo use the Reference Integrity. and next point: I can create a Foreign Key without using a .... Constraint <constraint-name> .... when I create a table. If I try a ALTER TABLE, I have to type ALTER TABLE mytable ADD CONSTRAINT myconstraintname FOREIGN KEY ... OOo don´t send a ADD CONSTRAINT, beause in the SQL92-Spec this is optional and should go without this. If you can change this, I think hsqldb is one of the best Databases to work with OOo. And hsqldb has a GUI. Have you ever tried OOo? again, hsqldb looks really great now!!! -- mfg Hermann Kienlein ------------------------------------------------------------------- EDV-Systeme Kienlein FON: +49-9184-80040 Pfarrer-Zinckel-Str. 10 FAX: +49-9184-80041 D-92364 Deining http://www.kienlein.com ------------------------------------------------------- This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger for complex code. Debugging C/C++ programs can leave you feeling lost and disoriented. TotalView can help you find your way. Available on major UNIX and Linux platforms. Try it free. www.etnus.com _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers ------------------------------------------------------- This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger for complex code. Debugging C/C++ programs can leave you feeling lost and disoriented. TotalView can help you find your way. Available on major UNIX and Linux platforms. Try it free. www.etnus.com _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
