table name limits changed since teradata 14.10

since teradata 14.10, the table name limits was changed from 30 bytes to 128 bytes
that's maybe a good news , but DO NOT FORGET that when we refernce the DBC.TABLES view,
the tablename column still show the table name in 30 bytes. you should use DBC.Tablesv to view the "REAL" 128 bytes table name.

so when you reference dbc.tables and you find that two or more table under the same name in the same database, do not confused, use help database or DBC.Tablesv you will found that they were cut off by the 30 bytes and loooks like "the same name"

Tweet