Archives of the TeradataForum
Message Posted: Wed, 08 Dec 2004 @ 16:05:40 GMT
The following SQL is not throwing an error when run from Sql assistant 6.2
create table t1( i int, j int) primary key (i) ;
As far as I know it should throw a syntax error as PRIMARY KEY constraint cannot be defined like above.
BTEQ is throwing an error but Queryman is converting the column to NUPI. ( Primary key should be made as UPI but I could see it as NUPI)
Is this a bug or am missing something here?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|