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

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Any DBC tables to find the row length of a...

Rate Topic

Display Mode

Topic Options

Author

Message

EDW ETL

Posted 3/14/2008 7:34:24 PM

Forum Newbie

Group: Forum Members
Last Login: 4/2/2008 8:38:38 PM
Posts: 1, Visits: 11

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

Post #10952

Jim Chapman

Posted 3/15/2008 12:22:18 AM

Supreme Being

Group: Forum Members
Last Login: Yesterday @ 8:47:37 PM
Posts: 283, Visits: 989

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.

Post #10954

Falcon_1

Posted 11/1/2009 10:41:32 PM

Forum Newbie

Group: Forum Members
Last Login: 11/1/2009 10:39:06 PM
Posts: 1, Visits: 2

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

Cheers

Post #17210

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 11:21am