Pages

Ads 468x60px

PRIMARY KEY AND FOREIGN KEY RELATIONSHIP WITH QUERY


create table tbl_LaptopImages
(
iLaptopImageID int not null identity(1,1), iLaptopID int,
vchImageName nvarchar(200),bMainImage bit,
constraint LaptopImages_pk primary key(iLaptopImageID),
constraint fk_tblLaptops_tblLaptopImages foreign key(iLaptopID) references tbl_Laptops(ILaptopID)
)

No comments:

Post a Comment