Archives of the TeradataForum
Message Posted: Tue, 29 Mar 2005 @ 10:11:50 GMT
I m creating table with JAVA program and my sql query is
CREATE TABLE UserData (UserID varchar (100) NOT NULL primary key ,Name varchar(100) ,Password varchar (100) NOT NULL ,Email varchar (100) ,Address varchar (100) )
and it gives me this exception
Syntax error, expected something like a 'CHECK' keyword between 'Name' and the 'Password' keyword.
can u help me why? this happens..
if I m replacing Password in create table query with TPassword then it works fine..
so that means in teradata we can't create table with column name as password i think it is reserved word..
so how can i overcome with this problem and i have to use column name as password
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|