sql,query Following are two CREATE TABLE statements. The second one fails because of an error in the last line.
Does anyone know why? Jim Bailey STATEMENT #1 CREATE TABLE IIM_InventoryItemMaster( IIM_InventoryItemMaster_ID MEDIUMINT(8) NOT NULL, IIM_ItemNm VARCHAR(64), IIM_ItemDescCD VARCHAR(1) DEFAULT 'U', IIM_GenderCD VARCHAR(1), IIM_ItemPN VARCHAR(36), IIM_Spec1Nm VARCHAR(48), IIM_Spec2Nm VARCHAR(48), IIM_RecordCreatedBY VARCHAR(24), IIM_RecordCreatedDT DATETIME, IIM_LastEditBY VARCHAR(24), IIM_LastEditDT DATETIME, PRIMARY KEY(IIM_InventoryItemMaster_ID), KEY(IIM_GenderCD), KEY(IIM_ITEMNm), KEY(IIM_ItemDescCD), key(IIM_ItemPN) ); STATEMENT #2 CREATE TABLE IID_InventoryItemDesc( IID_ItemDescCD VARCHAR(1) NOT NULL, IID_ItemDesc VARCHAR(24), IID_RecordCreatedBY VARCHAR(24), IID_RecordCreatedDT DATETIME, IID_LastEditBY VARCHAR(24), IID_LastEditDT DATETIME, PRIMARY KEY(IID_ItemDescCD), KEY (IID_ItemDesc), CONSTRAINT IIM_TO_IID FOREIGN KEY IIM_InventoryItemMaster (IIM_ItemDescCD) REFERENCES IIM_InventoryItemDesc( Primary key) MATCH FULL); _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx --------------------------------------------------------------------- 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
