Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 08 Feb 2008 @ 10:01:57 GMT


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


Subj:   Re: DDL ( Show Table ) from DBC tables
 
From:   sreenivasa.akula

Hi,

Show cmd is used to see the structure of the create table as follows. To get show desc. Just type the following cmd & the formate of the output as follows..

So I hope it'll help you to understand the output.

     show table odsadm.phonelist;

       *** Text of DDL statement returned.
       *** Total elapsed time was 1 second.

     --------------------------------------------------------------
     CREATE SET TABLE odsadm.phonelist ,FALLBACK ,
           NO BEFORE JOURNAL,
           NO AFTER JOURNAL
           (
            Number CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Number' NOT NULL,
            Name CHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Name' NOT NULL,
            LType CHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Line Type',
            Calls INTEGER FORMAT 'zzz9' TITLE 'Calls Made',
            Take CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Important')

     UNIQUE PRIMARY INDEX ( Number );


       BTEQ -- Enter your DBC/SQL request or BTEQ command:


     
  <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: 27 Dec 2016