UDA

turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

03-14-2008
07:34 PM

03-14-2008
07:34 PM

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

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

03-15-2008
12:22 AM

03-15-2008
12:22 AM

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.

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

11-01-2009
10:41 PM

11-01-2009
10:41 PM

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

group by tablename order by tablename