CREATE TABLE syntax error...

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!
Bodyboarder20 [ Mo, 10 September 2007 18:48 ] [ ID #1816534 ]

Re: CREATE TABLE syntax error...

NEVERMIND!

Im an idiot... Just needed to swap BOOLEAN for BIT...
Bodyboarder20 [ Mo, 10 September 2007 18:55 ] [ ID #1816535 ]
Datenbanken » comp.databases.ms-sqlserver » CREATE TABLE syntax error...

Vorheriges Thema: Identity Column in INFORMATION_SCHEMA or the sys tables
Nächstes Thema: Understanding tables as variables