Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Exception occur at create table
 
From:   Rajesh Maheshwari

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016