Teradata 14 DBC.Tables Column Length Issue for Tablename

[Sayandeep]

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.

[DaveWellman]

Don't use DBC.Tables.

Use DBC.TablesV.

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

Cheers,

Dave

[Sayandeep]

Thanks for the info. :)

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

[tomnolan]

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.

[David_Roth]

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

dave

[Sayandeep]

Thanks for the information !!