foreign key in sql server

create database shop use shop create table product(pid int primary key ,pname nvarchar(30),pp int,sp int)create table category(id int primary key,pname nvarchar(29))alter table product add cID int foreign key references category(id)