CREATE TABLE syntax error...

#1

CREATE TABLE Agents
(ID COUNTER NOT NULL CONSTRAINT constraintName_pk PRIMARY KEY,
Name VARCHAR(255),
Supervisor INTEGER,
MasterCalendarVisible BOOLEAN default false)

I'm using this against an Access DB using JET driver... I keep getting
a syntax error which goes away when I remove the last line... Any
ideas whats wrong with it?

Thanks!

#2

NEVERMIND!

Im an idiot... Just needed to swap BOOLEAN for BIT...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

CREATE TABLE syntax error...

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

CREATE TABLE syntax error... - 09-10-2007 , 11:48 AM

Re: CREATE TABLE syntax error... - 09-10-2007 , 11:55 AM