you've 2 commas missing at the end
CREATE TABLE ITEMS_ITEMDETAILS
(
ItemID int Identity(2,2) PRIMARY KEY ,
ItemName Varchar (50) not null,
ItemDescription Varchar (50) not null,
QuantityInHand int,
CONSTRAINT check_ID1 CHECK (QuantityInHand >= 0 ),
UnitPrice Money,
CONSTRAINT check_ID2 CHECK (UnitPrice >= 0 ),
ReorderQuantity int,
CONSTRAINT check_ID3 CHECK (ReorderQuantity >= 0 ),
ReorderLevel int ,
CONSTRAINT check_ID4 CHECK (ReorderLevel >= 0),
CategoryID int constraint fkey_CategoryID Foreign Key References ITEMS_PRODUCTCATEGORY(CategoryID),
SupplierID int constraint fkey_SupplierID Foreign Key References SUPPLIER_SUPPLIERDETAILS (SupplierID)
)
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs