Archives of the TeradataForum

Message Posted: Thu, 07 Apr 2005 @ 07:26:47 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Dave,

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.

Cheers,

Dave

	<Prev	Next>		<<First	<Prev	Next>	Last>>