Archives of the TeradataForum

Message Posted: Tue, 29 Mar 2005 @ 10:11:50 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

hi guys

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

Thanks

Rajesh Maheshwari

	<Prev	Next>		<<First	<Prev	Next>	Last>>