Primary and Foreign Key

//Priamry Table

create table tbluser(
UserId varchar(50) constraint [UID] primary key not null,
UserName varchar(100) not null)

//Foreign Key Table

create table tblUserPermission(
UserID varchar(50) constraint fkUId foreign key (UserId) references tbluser(UserId) not null)