Jamie Poole
asked on
Error message of invaild data type in SQL Server Management Studio Express
I am getting an error message iwhen I try to execute this statement. I am taking a course and this is the sample database to work with throughout the chapter, so this is copied straight from the book. Please tell me I have copied something down wrong.
/*------------------------
CREATE TABLE DEPARTMENT(
DepartmentName VARCHAR NOT NULL,
BudgetCode Char(30) NOT NULL,
OfficeNumber Char(15) NOT NULL,
Phone Char(12) NOT NULL,
CONSTRAINT DEPARTMENT_PK PRIMARY KEY (DepartmentName
);
CREATE TABLE EMPLOYEE(
EmployeeNumber Int NOT NULL IDENTITY (1,1)
FirstName Char(25) NOT NULL,
LastName Char(25) NOT NULL,
Department Char(35) NOT NULL, DEFAULT 'Human Resources'
Phone Char(12) Null,
Email VarChar(100) NOT NULL UNIQUE,
CONSTRAINT EMPLOYEE_PK PRIMARY KEY (EmployeeNumber),
CONSTRAINT EMP_DEPART_FK FOREIGN KEY (Department)
REFERENCES DEPARTMENT(DepartmentName)
ON UPDATE CASCADE
);
CREATE TABLE PROJECT(
ProjectID Int NOT NULL IDENTITY(1000, 100),
Name Char(50) NOT NULL,
Department Char(35) NOT NULL,
MaxHours Numeric(8,2) NOT NULL DEFAULT 100,
StartDate DateTime NULL,
EndDate DateTime NULL,
CONSTRAINT PROJECT_PK PRIMARY KEY(ProjectID),
CONSTRAINT PROJ_DEPART_FK FOREIGN KEY(Department)
REFERENCES DEPARTMENT (DepartmentName)
ON UPDATE CASCADE
);
CREATE TABLE ASSIGNMENT (
ProjectID Int NOT NULL,
EmployeeNumber Int NOT NULL,
HoursWorked Numeric(6,2) Null,
CONSTRAINT ASSIGNMENT_PK PRIMARY KEY (ProjectID, EmployeeNumber),
CONSTRAINT ASSIGN_PROJ_FK FOREIGN KEY(ProjectID)
REFERENCES PROJECT (ProjectID)
ON UPDATE NO ACTION
ON DELETE CASCADE,
CONSTRAINT ASSIGN_PROJ_FK FOREIGN KEY(EmployeeNumber)
REFERENCES EMPLOYEE (EmployeeID)
ON UPDATE NO ACTION
ON DELETE NO ACTION
);
------------------------*/
Major Error 0x80040E14, Minor Error 26302
> CREATE TABLE DEPARTMENT(
DepartmentName VARCHAR NOT NULL,
BudgetCode Char(30) NOT NULL,
OfficeNumber Char(15) NOT NULL,
Phone Char(12) NOT NULL,
CONSTRAINT DEPARTMENT_PK PRIMARY KEY (DepartmentName
)
The specified data type is not valid. [ Data type (if known) = VARCHAR ]
On your code snippet, check the end of line 7. You're missing a closing parenthesis on the CONSTRAINT line.
ASKER
CCongdon,
Thanks for noticing that, it still will not execute, Char does not turn blue, were Int and Numeric do.
Thanks for noticing that, it still will not execute, Char does not turn blue, were Int and Numeric do.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you