create table dbo.Users
(
 Id int identity not null 
  constraint Users_Id_PK primary key clustered (Id),
 Username nvarchar (40) not null
);
create table dbo.Profiles
(
 Id int not null
  constraint Profiles_UserId_PK primary key clustered (UserId),
 [Name] nvarchar (80) not null		
);

alter table dbo.Profiles
add constraint Profiles_UserId_FK foreign key (Id) references Users (Id) on delete cascade on update cascade;