Posted by bodyboarder20 on 09/10/07 16:48

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!

• Next in forum: Re: Identity Column in INFORMATION_SCHEMA or the sys tables
• Prev in forum: Re: Compare based on table values.
• Thread view: CREATE TABLE syntax error...

[Reply to this message]