All Forums Database
walee78 2 posts Joined 08/14
07 Aug 2014
Create Table Syntax Error

hi there.  I've never created a table using Teradata before.  I usually just query data instead.  Below is my first attempt at creating a table but I keep getting an error message of: CREATE TABLE Failed 3707: Syntax error, expected something like ',' between the 'int' keyword and '('.  I've looked on forums after forums on how to create a table in Teradata and what I have below seems to be correct.  Am I missing something?   Thanks in advance...

create table DACA

(COID int (3),

Acct int (20),

PC varchar (3),

"Class" int (1),

"Type" int (2),

effdate date,

expDate int (6),

St int (1),

Comments1 varchar (30),

Comments2 varchar (30),

Resn1 varchar (50),

Resn2 varchar (50))

primary index (acct);

dnoeth 4628 posts Joined 11/04
07 Aug 2014

There's no display width for INT in Teradata, this looks like MySQL syntax.
Simply remove it (int (1) -> int), if it's actually less digits you might consider 1, 2, 4 or 8 byte integers: BYTEINT/SMALLINT/INT/BIGINT

Dieter

walee78 2 posts Joined 08/14
07 Aug 2014

Oh...didn't realize that.  I'm used to SQL and not all that comfortable with Teradata as there's tons of nuances between the two.  Thanks so dnoeth!  

You must sign in to leave a comment.