Object names length for tablename col. in dbc.tables is still 30 char in TD 15

Database

Object names length for tablename col. in dbc.tables is still 30 char in TD 15

Starting 14.10 Object name length has been increased to 128 characters from earlier 30 byte.

But still the view dbc.tables's column ‘tablename’ is defined as 30 char only,

thus restricted the full use of this new feature, as we frequently use the view dbc.tables to search objects

and now as it’s only storing the first 30 char, string based search may result into multiple records.

Any workaround or fix available/planned for this. 

3 REPLIES
N/A

Re: Object names length for tablename col. in dbc.tables is still 30 char in TD 15

You do what is recommended since TD12, utilize the V-Views instead of the old legacy version:

select * from dbc.TablesV

Teradata Employee

Re: Object names length for tablename col. in dbc.tables is still 30 char in TD 15

Deiter is correct. For more details, refer to the Data Dictionary reference chapter on views, and the 14.10 Extended Object Names Orange Book. Our plans are to remove the compatibility views in the future.

-Dave

Re: Object names length for tablename col. in dbc.tables is still 30 char in TD 15

Thanks a ton Mr. Guru (Dieter) !!

Thanks Mr. Dave, will try to ref the orange book you've recommended.