Script sql server creación de tablas

CREATE TABLE "EMP"(
"EMPNO" "NUMERIC"(4) NOT NULL,
"ENAME" "VARCHAR"(10)NOT NULL,
"JOB" "VARCHAR"(9) NOT NULL,
"MGR" "NUMERIC"(4)NOT NULL,
"HIREDATE" "VARCHAR" (10) NOTNULL,
"SAL" "NUMERIC"(7,2)NOT NULL,
"COMM" "VARCHAR"(7) NOT NULL,
"DEPTNO" "VARCHAR"(10) NOT NULL,
"GRADE" "NUMERIC"(2)NOT NULL
)

CREATE TABLE "DEPT"
( "DEPTNO""VARCHAR"(10) NOT NULL,
"DNAME" "VARCHAR"(14) NOT NULL,
"LOC" "VARCHAR"(13) NOT NULL)

CREATE TABLE "SALEGRADE"
( "GRADE" "NUMERIC"(2) NOT NULL,
"LOSAL" "VARCHAR"(14)NOT NULL,
"HISAL""VARCHAR"(13) NOT NULL)

CREATE TABLE "BONUS"
( "EMPNO" "NUMERIC"(4) NOT NULL,
"JOB" "VARCHAR"(14),
"SAL" "VARCHAR"(13),
"COM" "VARCHAR" (14))

drop table BONUS

ALTER TABLE "EMP" ADDCONSTRAINT pk_EMP PRIMARY KEY ("EMPNO");
ALTER TABLE "DEPT" ADD CONSTRAINT pk_DEPT PRIMARY KEY ("DEPTNO");
ALTER TABLE "SALEGRADE" ADD CONSTRAINT pk_SALEGRADE PRIMARY KEY ("GRADE");

ALTER TABLE"EMP" ADD FOREIGN KEY ("DEPTNO") REFERENCES "DEPT"
ALTER TABLE "EMP" ADD FOREIGN KEY ("GRADE") REFERENCES "SALEGRADE"
ALTER TABLE "BONUS" ADD FOREIGN KEY ("EMPNO") REFERENCES "EMP";

insertinto "EMP" values(7329,'SMITH','CLERK',7902,'17-DEC-80',800, ' ', 20, 1);
insert into "EMP" values(7499,'ALLEN','SALESMAN',7698,'20-FEB-81', 1600, 300, 30,3);
insert into "EMP"values(7521,'WARD"','SALESMAN',7698,'22-FEB-81', 1250, 500, 30, 2);
insert into "EMP" values(7566,'JONES','MANAGER',7839,'02-APR-81', 2975, ' ', 20, 4);
insert into "EMP"values(7654,'MARTIN','SALESMAN',7698,'28-SEP-81', 1250, 1400, 30, 2);
insert into "EMP" values(7698,'BLAKE','MANAGER',7839,'01-MAY-81', 2850, ' ', 30, 4);
insert into "EMP" values(7782,'CLARK','MANAGER',7839,'09-JUN-81', 2450, ' ', 10, 4);insert into "EMP" values(7788,'SCOTT','ANALYST',7566,'09-DEC-82', 3000, ' ', 20, 4);
insert into "EMP" values(7844,'TURNER','SALESMAN',7698,'08-SEP-81', 1500, 0, 30, 3);
insert into "EMP"...