CREATETABLE[dbo].[ICDeliveryMethods] ( [DeliveryMethodID][int]NOTNULL, [DeliveryMethod][varchar](32)COLLATESQL_Latin1_General_CP1_CI_ASNOTNULL )ON[PRIMARY] GO ALTERTABLE[dbo].[ICDeliveryMethods]ADDCONSTRAINT[PK_ICDeliveryMethods]PRIMARYKEYCLUSTERED([DeliveryMethodID])ON[PRIMARY] GO