All Forums Database
ap0167 1 post Joined 08/16
17 Aug 2016
SQL Error on 'Create Table' in Terdata SQL Assistant

why I am getting a syntax error?
 
create TABLE  ddwp_v.sponsoredm, CHECK = DEFAULT
(account VARCHAR(12)
 Unique Primary INDEX(account);
insert into ddwp_v.sponsoredm
VALUES(?);

 

Tags:
dnoeth 4628 posts Joined 11/04
18 Aug 2016

Simply read the error message:

CREATE TABLE Failed.  [3707] Syntax error, expected something like a 'LOG' keyword or a 'QUEUE' keyword between ',' and the 'CHECK' keyword.

It's CHECKSUM instead of CHECK (and you simply remove it, too).
 
If you use a .Net connection SQLA will indicate the position of the error with a red line, too.

Dieter

You must sign in to leave a comment.