All Forums Database
atalukder 16 posts Joined 01/12
16 Jan 2013
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
 
 

KS42982 137 posts Joined 12/12
16 Jan 2013
ToddAWalter 316 posts Joined 10/11
16 Jan 2013

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.

atalukder 16 posts Joined 01/12
17 Jan 2013

Thanks   for the info  Todd.

SHERIN JEYABOSE 18 posts Joined 11/14
12 Nov 2014

What is the maximum length of table name in Teradata 14.10

Raja_KT 1246 posts Joined 07/09
12 Nov 2014

It is 128.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

SHERIN JEYABOSE 18 posts Joined 11/14
12 Nov 2014

Thanks Raja.

ManishM 5 posts Joined 01/08
21 Apr 2015

I think its still 30 Char

Manish

tomnolan 594 posts Joined 01/08
21 Apr 2015

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.

Rakesh Gupta 2 posts Joined 12/14
11 Mar 2016

What is max table name length in teradata 15 ?

dnoeth 4628 posts Joined 11/04
11 Mar 2016

The same as in TD14.10, 128.
http://www.info.teradata.com/htmlpubs/DB_TTU_15_00/index.html#page/Database_Management/B035_1094_015K/appb.070.09.html#ww14482536

Dieter

You must sign in to leave a comment.