Table ID and Table Name

Database
Enthusiast

Table ID and Table Name

DBC.TVM contains the tableid .Is there any dictionary table which can provide the information of the table name for the corresponding tableids?

Thanks,

Kishore

Tags (2)
5 REPLIES
Enthusiast

Re: Table ID and Table Name

You can join DBC.Dbase,DBC.TVFields,DBC.TVM . Let me know.

Cheers,

Enthusiast

Re: Table ID and Table Name

Thanks Raja!It worked.

KVB
Enthusiast

Re: Table ID and Table Name

Really it's a good one! Thank you Raja.

Teradata Employee

Re: Table ID and Table Name

would someone please show me the exact syntax for this 3 way join?

thanks

Teradata Employee

Re: Table ID and Table Name

This is why there is a DBC.Tables view. The views in DBC do all the joins for you so you don't have to know the details of linking tableids, databaseids,... The views should always be used rather than direcct access to the DBC tables.

A SHOW VIEW on the DBC views can also help understand how the underlying tables work.