Increase the size limit of teradata objects name from 30 characters to more.

Database
Enthusiast

Increase the size limit of teradata objects name from 30 characters to more.

Is there any decision to increase the size limit of teradata objects name like database, table, view etc)   from 30 character to  more?

 If teradata is considering it, then which version of teradata  will introduce   this ?

Thanks,

Akleema Talukder

10 REPLIES
Enthusiast

Re: Increase the size limit of teradata objects name from 30 characters to more.

Teradata Employee

Re: Increase the size limit of teradata objects name from 30 characters to more.

It is currently intended that Teradata 14.10 due out later this year will increase this limit. As always, this is not a promise, only the official release content documentation can describe the actual content of the release. But this item is actively being engineered.

Enthusiast

Re: Increase the size limit of teradata objects name from 30 characters to more.

Thanks   for the info  Todd.

Enthusiast

Re: Increase the size limit of teradata objects name from 30 characters to more.

What is the maximum length of table name in Teradata 14.10

Enthusiast

Re: Increase the size limit of teradata objects name from 30 characters to more.

It is 128.

Enthusiast

Re: Increase the size limit of teradata objects name from 30 characters to more.

Thanks Raja.

Enthusiast

Re: Increase the size limit of teradata objects name from 30 characters to more.

I think its still 30 Char

Teradata Employee

Re: Increase the size limit of teradata objects name from 30 characters to more.

Teradata Database 14.10 and later releases support object names (such as database names, table names, column names, etc.) up to 128 characters in length.

Keep in mind that you must query the Data Dictionary "V" views in order to see the longer object names. For example, you must query DBC.TablesV, DBC.ColumnsV, etc.

The older legacy compatibility views such as DBC.Tables and DBC.Columns are limited to the first 30 characters of the object names.

Teradata Employee

Re: Increase the size limit of teradata objects name from 30 characters to more.

What is max table name length in teradata 15 ?