how to create foreign key in sql

create table employee
(
   employeeId int not null,
   employeeUsername varchar(50) not null,
   employeePassword varchar(50) not null,
   employeeName varchar(50) not null,
   employeeContact int not null,
   employeeEmail varchar(30) not null,
   Constraint PK_Employee PRIMARY KEY(employeeId)
)
 
Create table artist
{
   artistId INT NOT NULL CONSTRAINT FK_artist_artistId
      FOREIGN KEY REFERENCES Employee(employeeId), --ON DELETE CASCADE this is optional if you want to 
   artistUsername varchar(50) not null,
   artistPassword varchar(50) not null,
   artistName varchar(50) not null,
   artistContactno int not null,
   artistAddress varchar(50) not null,
   artistEmail varchar(50) not null,
   artistDob datetime not null,
   artistRegdate datetime not null
);