Teradata 14 DBC.Tables Column Length Issue for Tablename

Database
Enthusiast

Teradata 14 DBC.Tables Column Length Issue for Tablename

Hi Team,

 

In TD 14 we are allowed to create tables with names more than 30 characters, but in dbc.tables the length for tablename is still 30, so if we give a tablename like dbname.sample_table_in_teradata_fourteen , then in dbc.tables we need to search with tablename = 'sample_table_in_teradata_fourt' .

 

I guess this needs to be fixed in order to retrieve correct table name from dbc table.

 

 

 

5 REPLIES
Senior Apprentice

Re: Teradata 14 DBC.Tables Column Length Issue for Tablename

Don't use DBC.Tables.

 

Use DBC.TablesV.

 

Recommend that you use the 'V' views as standard.

 

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Enthusiast

Re: Teradata 14 DBC.Tables Column Length Issue for Tablename

Thanks for the info. :)

 

But any specific reason to use tablesv , apart from the column names .The FROM clause in both views are same.

Teradata Employee

Re: Teradata 14 DBC.Tables Column Length Issue for Tablename

The non-V views are deprecated, meaning they are outdated and obsolete. They continue to be provided for legacy scripts and applications, but you should stop using the non-V views as soon as you can, and switch over to using the V views.

 

Any new scripts and applications should use the V views. As new features are added to the Teradata Database, new columns will be added to the V views.

 

All the object names (database, table, column, UDT type names, etc.) are truncated in the non-V views.

Teradata Employee

Re: Teradata 14 DBC.Tables Column Length Issue for Tablename

and, you will find that the V views are more performant, faster.

 

dave

Highlighted
Enthusiast

Re: Teradata 14 DBC.Tables Column Length Issue for Tablename

Thanks for the information !!