Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 30 Nov 2001 @ 21:46:37 GMT

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

Subj:   Re: Source for DDL in SHOW TABLE
From:   John Hall

Hi Dieter,

Yep, I'm afraid that I had a simple example in mind and I didn't consider things like FREESPACE, et al. My belief about SHOW TABLE reconstructing from the data dictionary is that it is the way that it used to work before V2R2. I think that FREESPACE and DATABLOCKSIZE were added about V2R2 and so SHOW TABLE might have changed at that time. Now it's probably a combination of the Table Header (for things like FREESPACE, et al) and the data dictionary for just about everything else (things like default values, comments, formats, nulls, compress, etc).

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023