Home deelliiee456 Promote

deelliiee456

In LinqPad I wrote this querry CREATE TABLE InventoryTBLC ( itemID int NOT NULL IDENTITY(1,1) CONSTRAINT PK_items PRIMARY KEY, itemName NVARCHAR(150) NOT NULL, itemDesc NVARCHAR(150) NULL, itemQuantity int, itemPrice int, imagePath NVARCHAR(300), correctInsert NVARCHAR(300), realImage image, catID INT NOT NULL CONSTRAINT FK_item_Category FOREIGN KEY REFERENCES Category(catID) ); But it gives error "The constraint specified is not valid." Can someone tell me the correct syntax for adding foreign key