Any DBC tables to find the row length of a table?

UDA

Any DBC tables to find the row length of a table?

Hi,

Is there any DBC tables that I can use to find out what's the Total Row Length of a row in the TERADATA table?

Thanks
2 REPLIES

Re: Any DBC tables to find the row length of a table?

No, not directly. You should be able to estimate the length by adding the lengths of the columns.

Another estimating method that could be used for a populated table to get the the amount of disk space occupied from the DBC.TableSize view and divide by the number of rows.

Re: Any DBC tables to find the row length of a table?

sel tablename , sum(columnlength) from dbc.columns where databasename = 'Your Database Name Here' and tablename in ('Your Table Names Here'' )

group by tablename order by tablename