New to Teradata Help with data type

Database
Enthusiast

New to Teradata Help with data type

I found a document on this site that shows various data types, however I do not see phone or email related data types. Can anyone point me to how I set up this type of datatype?

3 REPLIES
Senior Apprentice

Re: New to Teradata Help with data type

A phone or email is simply a VarChar with some added validation rules.

Which DBMS has built in dataypes like that?

Enthusiast

Re: New to Teradata Help with data type

Access lets you do text and then you have to format it but was not sure if teradata was different. So, I will Google validation rules to see how to set up validation.

Enthusiast

Re: New to Teradata Help with data type

If you check the phone formats of each country, you will see some formats and some countries have quite a number :) . I don't think any DBMS will resort to using phone as a datatype.