Database information functions

Database
Teradata Employee

Database information functions

Hi All,
Kindly tell me some functions that are beneficial to get the database objects detail information.

Such that, I order to get the detail information of a table like all the columns name and their respective datatype which function should be used.
1 REPLY
Enthusiast

Re: Database information functions

You must get most of that information from the DD manual (actually you will have to query the corresponding views under DBC for most of the information).

DBC.Columns has the data type info.

you can also use the TYPE function

ie

SEL TYPE(mytable.mycolname);

to obtain the data type of the column.