Archives of the TeradataForum

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

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

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>>