Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 19 Jan 2007 @ 07:46:46 GMT


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


Subj:   Re: COLUMNTYPE LOOKUP
 
From:   Hanson, Robert

Here are the descriptions from the Data Dictionary manual.

You can create a table in Teradata and store the columntype and the description for future reference.

     * AT = TIME
     * BF = BYTE
     * BO = BLOB
     * BV = VARBYTE
     * CF = CHAR
     * CO = CLOB
     * CV = VARCHAR
     * D = DECIMAL
     * DA = DATE
     * DH = INTERVAL DAY TO HOUR
     * DM = INTERVAL DAY TO MINUTE
     * DS = INTERVAL DAY TO SECOND
     * DY = INTERVAL DAY
     * F = FLOAT
     * GF = GRAPHIC
     * GV = VARGRAPHIC
     * HM = INTERVAL HOUR TO MINUTE
     * HR = INTERVAL HOUR
     * HS = INTERVAL HOUR TO SECOND
     * I1 = BYTEINT
     * I2 = SMALLINT
     * I = INTEGER
     * MI = INTERVAL MINUTE
     * MO = INTERVAL MONTH
     * MS = INTERVAL MINUTE TO SECOND
     * SC = INTERVAL SECOND
     * SZ = TIMESTAMP WITH TIME ZONE
     * TS = TIMESTAMP
     * TZ = TIME WITH TIME ZONE
     * YM = INTERVAL YEARTO MONTH
     * YR = INTERVAL YEAR
     * UT = UDT Type


     
  <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: 28 Jun 2020