Re: Constraint Confusion

2002-08-19 Thread Egor Egorov
Jim, Monday, August 19, 2002, 3:19:36 PM, you wrote: JB> Following are two CREATE TABLE statements. The second one fails because of JB> an error in the last line. JB> Does anyone know why? JB> STATEMENT #2 JB> CREATE TABLE IID_InventoryItemDesc( JB> IID_ItemDescCD VARCHAR(1) NOT NULL, JB> IID

Constraint Confusion

2002-08-19 Thread Jim Bailey
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(