Friday, June 19, 2015

Teradata Data type abbreviation - described

Teradata data types (as reported in DBC.Columns.ColumnType can be cryptic and not always easy to remember.  Here's a ready reckoner - 

Abbreviation
Equivalent English :)
A1
ARRAY  
AN
MULTI-DIMENSIONAL ARRAY 
AT
TIME  
BF
BYTE  
BO
BLOB  
BV
VARBYTE  
CF
CHARACTER  
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  
HM
INTERVAL HOUR TO MINUTE
HS
INTERVAL HOUR TO SECOND
HR
INTERVAL HOUR 
I
INTEGER  
I1
BYTEINT  
I2
SMALLINT  
I8
BIGINT  
JN
JSON  
MI
INTERVAL MINUTE 
MO
INTERVAL MONTH 
MS
INTERVAL MINUTE TO SECOND
N
NUMBER  
PD
PERIOD(DATE)  
PM
PERIOD(TIMESTAMP WITH TIME ZONE)
PS
PERIOD(TIMESTAMP)  
PT
PERIOD(TIME)  
PZ
PERIOD(TIME WITH TIME ZONE)
SC
INTERVAL SECOND 
SZ
TIMESTAMP WITH TIME ZONE
TS
TIMESTAMP   
TZ
TIME WITH TIME ZONE
UT
UDT Type 
XM
XML  
YM
INTERVAL YEAR TO MONTH
YR
INTERVAL YEAR 
=++
TD_ANYTYPE  

15 comments:

  1. Ken Academy is the premier institute for SAP courses London. Ken offer a practical industry-led approach. Ken has emerged as a destination of choice among the students. We have trained enormous students individual as well as corporates who are looking for excelling and building a career in SAP.

    ReplyDelete
  2. Maple Hill Outsourcing services is a specialist outsourcing provider working specifically for Uk businesses of all size. Our team is qualified and highly trained in almost every software used in the accounting world.

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. You can also search the best technology on JanBask Training .It's knowledge hub where they share the information & technology in an easiest way.

    ReplyDelete
  5. It is perfect time to make some plans for the future and it is time to be happy. I’ve read this post and if I could I desire to suggest you few interesting things or tips. Perhaps you could write next articles referring to this article. I want to read more things about it! Nisar Technology

    ReplyDelete
  6. There is definately a great deal to know about this subject. I like all of the points you've made. smoking pipes

    ReplyDelete
  7. It is perfect time to make some plans for the future and it is time to be happy. I’ve read this post and if I could I desire to suggest you few interesting things or tips. Perhaps you could write next articles referring to this article. I want to read more things about it! Car Accessories

    ReplyDelete
  8. Nice knowledge gaining article. This post is really the best on this valuable topic. wheel refurbishment

    ReplyDelete
  9. very well explained. I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Logistic Regression explained
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm
    Bag of Words Python

    ReplyDelete
  10. Enjoyed reading the article above , really explains everything in detail,the article is very interesting and effective.Thank you and good luck for the upcoming articles

    Selenium Training in Chennai

    ReplyDelete
  11. very well explained. I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Try SAP BPC Training

    ReplyDelete
  12. DevOps Training in Hyderabad .DevOps is a software engineering practice that aims at unifying software development and software operation. Spend more time on the code that matters and less on the tasks that slow your developers down.
    DevOps Training in Hyderabad

    DevOps Course in Hyderabad

    ReplyDelete
  13. Nice post. Thanks for sharing! I want people to know just how good this information is in your article. It’s interesting content and Great work.
    Power BI Training in Hyderabad
    Power BI Training in Ameerpet

    ReplyDelete
  14. This is awesome article. Thanks for sharing.
    devops online training

    ReplyDelete