I seem to be posting here a lot the past few days but as I am new to SQL Server I am finding to quite a pain to get used to!
I am having a problem referencing foreign keys. I did post another thread about this but this is a slightly different problem.
everytime I try to reference a foreign key SQL Server says -
'There is already an object named 'ProductID' in the database.'
yes there is another Product ID in the Product table, why won't SQL Server recognise that it is a foreign key and needs to be in this table too? This is happening quite a lot when I am creating the tables and trying to reference the foreign key (not just ProductID). Here is the code for two of my tables:-
CREATE TABLE HireLine ( HireID INT IDENTITY NOT NULL , ProductID INT NOT NULL, Quantity INT NULL, PRIMARY KEY (HireID), CONSTRAINT ProductID FOREIGN KEY (ProductID) REFERENCES Product (ProductID) ON DELETE CASCADE ON UPDATE CASCADE, );
CREATE TABLE CorderLine ( CorderID INT, ProductID INT, Quantity INT NOT NULL, PRIMARY KEY (CorderID, ProductID), CONSTRAINT CorderID FOREIGN KEY (CorderID) REFERENCES Corder (CorderID) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT ProductID FOREIGN KEY (ProductID) REFERENCES Product (ProductID) ON DELETE CASCADE ON UPDATE CASCADE, );
has anyone any ideas of where I am going wrong?