Question: please correct any syntax errors using sql CREATE TABLE EMPLOYEE 2) (SSN Number CHAR(9) NOT NULL, First Name VARCHAR(15) NOT NULL, Mid Name CHAR, N
CREATE TABLE EMPLOYEE 2) (SSN Number CHAR(9) NOT NULL, First Name VARCHAR(15) NOT NULL, Mid Name CHAR, N Last Name VARCHAR(15) NOT NULL, SRYD Birthday DATE, CGN) Address VARCHAR(50) 8) Gender CHAR CHECK (Gender IN (**', 'F', 'm', 'f')). 9 Salary MONEY INTEGER DEFAULT 80000", 10> Supervisor SSN CHAR(9), 11) Department Number INT 12) CONSTRAINT EMPLOYEE PK PRIMARY KEY (SSN Number), 13) CONSTRAINT EMPLOYEE_FK FOREIGN KEY (Supervisor SSN)); Msg 102, Level 15, State 1, Server HRZN-VDT-0061\LOCALOBN488CDB72, Line 2 Incorrect syntax near *CHAR. 1480
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
