I am trying to Create a table from DDL code.

Upon running the query I get the error: Syntax error in CREATE TABLE
statement. (Error 3290)

Here is my code after making many changes to it:

CREATE TABLE ACCOUNTABILITY (
OBJECTID number (22) NOT NULL,
OBJECTOWNERID decimal (22),
COMMISOID decimal (22),
RESPONOID decimal (22),
COMMISOBJECTTYPE CHARACTER (5),
RESPONOBJECTTYPE CHARACTER (5),
ACCOUNTYPEOID decimal (22),
BEGINDATE TIMESTAMP,
ENDDATE TIMESTAMP,
OBJECTTYPE CHARACTER (5),
ACL decimal (22),
REPLICNUMBER INTEGER,
ROWLASTCHANGE TIMESTAMP NOT NULL)
;

Any suggestions? I am all ears and eyes.

Zuf

zufie wrote:

Are you running this in Access or something like SQL Server or Oracle?
If Access, which version?

http://www.w3schools.com/sql/sql_datatypes.asp