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