Archives of the TeradataForum
Message Posted: Thu, 07 Apr 2005 @ 07:26:47 GMT
The nearest that you'll get in a query is dbc.columns.columnlength. That gives you 'internal length' (i.e. storage length') for most column types.
The things that you have to remember in addition are:
- for VARCHAR, VARBYTE etc columns you need to add 2 bytes
- for TIMESTAMP, TIME, INTERVAL columns the value shown is display length, you just have to know the stored length
- add on the row o/head bytes
- always round up to an even number
I've seen a worksheet on one of the Teradata courses (Physical Design I think) which 'someone' probably has as an Excel spreadsheet. That may help you.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|