How do i put in an integrity constraint? ie. say i have 2 tables Person (PersonID[pk], PersonName) School (SchoolID[pk], SchoolName, PersonID[fk]) as you can see PersonID is the foreign key in School. So how do keep update and delete restricted constraints etc,? could anyone tell me the SQL code for bot the tables? duke. Website: http://www.ilug-bom.org.in/ Ftp site: ftp.ilug-bom.org.in Chat: irc.ilug-bom.org.in Linuxers mailing list: [EMAIL PROTECTED] http://ilug-bom.org.in/mailman/listinfo/linuxers ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1 --------------------------------------------------------------------- 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
