CREATE TABLE "Employees" (
  "EmpNo"  IDENTITY  NOT NULL,
  "EmpName" nvarchar(2048),
  "Designation" nvarchar(2048),
  "Salary" bigint NOT NULL,
  "DeptNo" integer NOT NULL,
 PRIMARY KEY ("EmpNo") 
);
ALTER TABLE "Employees" ADD CONSTRAINT "Employee_Department" FOREIGN KEY ("DeptNo") REFERENCES "Departments"("DepartmentNo") ON DELETE CASCADE;