Does anyone have any idea about when MySQL is going to support this. Or if it already does? Here is an excerpt from a book I have been reading on MySQL....... "..... THE Create Table STATEMENT Tables are created with CREATE TABLE. The full syntax for this statement is pretty horrendous because there are so many optional clauses, but in practive this statement is usually fairly simple to use..... ...Ironically, much of this additional complexity comes from clauses that MySQL parses and the throws away! You can see this complexity by referring to Appendix D. Take a look at the entry for CREATE TABLE and notice how much of the statement syntax is devoted to the REFERENCES, CONSTRAINT, and CHECK clauses. Those clauses concern foreign keys, referential integrity, and input value restriction. MySQL doesn't support these features...... " Please tell me that they are already implemented or will be VERY soon, otherwise, as much as I hate to say it, MySQL is useless to me..... I am not on the mailing list, please respond to my email address. It is : [EMAIL PROTECTED] Thank You In Advance, Thomas Ince Systems Software Engineer Atlantic Consulting Services --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php