Archives of the TeradataForum

Message Posted: Thu, 16 Aug 2007 @ 19:28:02 GMT

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

Hi,

Here's some additional information:

I have a table :

     CREATE SET TABLE CUST ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           Cust_Sk DECIMAL(15,0) TITLE 'Customer Account Sk' NOT NULL GENERATED ALWAYS AS IDENTITY
                (START WITH -999999999999999
                 INCREMENT BY 1
                 MINVALUE -999999999999999
                 MAXVALUE 0
                 NO CYCLE),
          Num1 VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC TITLE ' Account Num',
           Num2 VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Ban Num' CHECK (NUM2 BETWEEN 1 AND 10),
           Num3 VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Service Num' CHECK (NUM3 >20),
           Src_Id INTEGER TITLE 'Source Id'
           )
     UNIQUE PRIMARY INDEX Cust_Acct_UP ( Cust_Sk )
     UNIQUE INDEX CUST_ACCT_US2 ( Num1 ,Num2 ,Num3 ,Src_Id )
     INDEX CUST_ACCT_NS ( Num2 );

How can I find the constraint on this table. I have used this SQL :

     select ColCheck(char(200)) from dbc.SHOWCOLCHECKS where
     Databasename='db' and TableName='cust'

But it shows no result. Can anyone help out

Thanks.

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