Foreign key

Question posted by: sva0008 (Newbie) on June 30th, 2008 04:57 PM

I have a table name product
that have column productCode (primary key), name address , ph , warehouse .

I want to create a new table with columns productcode and price.

with productcode as primary key and foreign key to productinfo table.

I am new to sql server can anyone let me know how to make it foreign key.

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).

amitpatel66

Moderator

1,837 Posts

July 1st, 2008
10:54 AM
#2

Re: Foreign key

Code: ( text )

-- if the table is already created:
ALTER TABLE Match_Scores
ADD CONSTRAINT [FK_Match_Scores_Matches] FOREIGN KEY (Match_Id)
REFERENCES [Matches] ([Match_Id])
GO
CREATE TABLE works_on (emp_no INTEGER NOT NULL,
project_no CHAR(4) NOT NULL,
job CHAR (15) NULL,
enter_date DATETIME NULL,
CONSTRAINT prim_works PRIMARY KEY (emp_no, project_no),
CONSTRAINT foreign_works FOREIGN KEY (emp_no) REFERENCES employee (emp_no))

akashazad

Newbie

24 Posts

July 2nd, 2008
06:42 PM
#3

Re: Foreign key

Hi ,
I think this will help U out

CREATE TABLE ProductInfo
(
ProductCode INT,
ProductName VARCHAR (20),
SupplierName VARCHAR (30),
PRIMARY KEY (ProductCode)
)

CREATE TABLE ProductSale
(
ProductCode INT,
CustomerName VARCHAR (20),
Amount DOUBLE,
PRIMARY KEY (ProductCode),
FOREIGN KEY (ProductCode) REFERENCES ProductInfo (ProductCode)
)

Not the answer you were looking for? Post your question . . .
182,197 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Top Microsoft SQL Server Contributors