CREATETABLE[dbo].[ICStockingCodes] ( [StockingCodeID][int]NOTNULL, [StockingCode][varchar](32)COLLATESQL_Latin1_General_CP1_CI_ASNOTNULL )ON[PRIMARY] GO ALTERTABLE[dbo].[ICStockingCodes]ADDCONSTRAINT[PK_ICStockingCodes]PRIMARYKEYCLUSTERED([StockingCodeID])ON[PRIMARY] GO