SQL$HELP72.HLB  —  DECLARE  TABLE  Format
  (B)0DECLARE qqwq> <table-name> qwq> TABLE qqk          
            mq> <view-name> qqj           x          
    lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj          
    mq> ( qwwq> declare-col-definition qwwq> ) qq>   
           xmq> table-constraint qqqqqqqjx           
           mqqqqqqqqqq , <qqqqqqqqqqqqqqqj           

  (B)0declare-col-definition =                                        
                                                                  
  qq> <column-name> qq> data-type qwwqqqqqqqqqqqqqqqqqqqqqqqqwwq> 
                                   xtq> col-constraint qqqqqqux   
                                   xmq> sql-and-dtr-clause qqjx   
                                   mqqqqqqqqqqq <qqqqqqqqqqqqqj   
                                                                  

  (B)0data-type =                                                           
                                                                        
   qwq> char-data-types qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq>   
    tq> TINYINT qqqqqqqqqqqqqqwqqqqqwqqqqqqqqqqqqwqqqqqqqqqqqqqqqu      
    tq> SMALLINT qqqqqqqqqqqqqu     mq> ( <n> ) qj               x      
    tq> INTEGER qqqqqqqqqqqqqqu                                  x      
    tq> BIGINT qqqqqqqqqqqqqqqu                                  x      
    tq> FLOAT qqqqqqqqqqqqqqqqj                                  x      
    tq> NUMBER qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqqu      
    x           mq> ( qwq> <p> qwqwqqqqqqqqqqwq> ) j             x      
    x                  mq> * qqqj mq> , <d> qj                   x      
    tq> LIST OF BYTE VARYING qqwqqqqqqqqqqqqwqqwqqqqqqqqqqqqqqwqqu      
    x                          mq> ( <n> ) qj  tq> AS BINARY qu  x      
    x                                          mq> AS TEXT qqqj  x      
    tq> DECIMAL qwwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqqqqu      
    tq> NUMERIC qjmq> ( qq> <n> wqqqqqqqqqqwq> ) j               x      
    x                           mq> , <n> qj                     x      
    tq> REAL qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu      
    tq> DOUBLE PRECISION qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu      
    mq> date-time-data-types qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj      
                                                                         

  (B)0char-data-types =                                                      
                                                                         
  qwq> CHAR qqqqqqqqqqqqqwwqqqqqqqqqqqqwwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwq>
   tq> CHARACTER qqqqqqqqumq> ( <n> ) qjmq> CHARACTER SET char-set-name qj x  
   tq> CHAR VARYING qqqqqu                                                 x  
   tq> CHARACTER VARYING j                                                 x  
   tq> VARCHAR qqw> ( <n> ) qqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqu  
   tq> VARCHAR2 qj             mq> CHARACTER SET char-set-name qj          x
   tq> LONG VARCHAR  qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu  
   tq> NCHAR qqqqqqqqqqqqqqwqwqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu 
   tq> NATIONAL CHAR qqqqqqu mq> ( <n> ) qj                                x  
   tq> NATIONAL CHARACTER qj                                               x  
   tq> NCHAR VARYING qqqqqqqqqqqqqqwqwqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqu
   tq> NATIONAL CHAR VARYING qqqqqqu mq> ( <n> ) qj                        x  
   tq> NATIONAL CHARACTER VARYING qj                                       x  
   tq> RAW q> ( <n> ) qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
   mq> LONG qwqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj  
             mq> RAW qj

  (B)0date-time-data-types =                        
                                                
  qqwq> DATE qwqqqqqqqqqqwqqqqqqqqqqqqqqqqqwqq> 
    x         tq> ANSI  qu                 x    
    x         mq> VMS qqqj                 x    
    tq> TIME qqq> frac qqqqqqqqqqqqqqqqqqqqu    
    tq> TIMESTAMP qq> frac qqqqqqqqqqqqqqqqu    
    mq> INTERVAL qqq> interval-qualifier qqj    
                                                

  (B)0frac =                            
                                    
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqwq> 
    mqq> ( <numeric-literal> ) qj   
                                    

  (B)0interval-qualifier =                                       
                                                             
  qqwq> YEAR qqq> prec qqwqqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqwq> 
    x                    mq> TO MONTH qj                 x   
    tq> MONTH qq> prec qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu   
    tq> DAY qqqq> prec qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu   
    x                    mq> TO qwq> HOUR qqqqqqqqqqqqqqqu   
    x                            tq> MINUTE qqqqqqqqqqqqqu   
    x                            mq> SECOND q> frac qqqqqu   
    tq> HOUR qqq> prec qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu   
    x                    mq> TO qwq> MINUTE qqqqqqqqqqqqqu   
    x                            mq> SECOND q> frac qqqqqu   
    tq> MINUTE q> prec qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu   
    x                    mq> TO SECOND qqqqqq> frac qqqqqu   
    mq> SECOND q> seconds-prec qqqqqqqqqqqqqqqqqqqqqqqqqqj   
                                                             

  (B)0prec =                            
                                    
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqwq> 
    mqq> ( <numeric-literal> ) qj   
                                    

  (B)0seconds-prec =                                
                                                
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq> 
    mq> ( <numeric-literal-1> qqqk         x    
       lqqqqqqqqqqqqqqqqqqqqqqqqqj         x    
       mwqqqqqqqqqqqqqqqqqqqqqqqqqqwq> ) qqj    
        m> , <numeric-literal-2> qqj            
                                                

  (B)0col-constraint=                           
                                            
  qqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqk  
      m> CONSTRAINT <constraint-name> qj x  
    lqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqj  
    tq> PRIMARY KEY qqqqqqqqqqqqqqqqqk      
    tq> UNIQUE qqqqqqqqqqqqqqqqqqqqqqu      
    tq> NOT NULL qqqqqqqqqqqqqqqqqqqqu      
    tq> NULL qqqqqqqqqqqqqqqqqqqqqqqqu
    tq> CHECK (predicate) qqqqqqqqqqqu      
    tq> references-clause qqqqqqqqqqqu      
    mqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqu      
    lqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqj      
    mqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq>  
         mqq> constraint-attributes qqj     

  (B)0constraint-attributes =                                            
                                                                     
  qwq> DEFERRABLE qqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwq>  
   x                           mq> INITIALLY wq> IMMEDIATE qqwj x    
   x                                         mq> DEFERRED qqqj  x    
   tq> NOT DEFERRABLE qqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqu    
   x                           mq> INITIALLY IMMEDIATE qqj      x    
   tq> INITIALLY IMMEDIATE qqqqwqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqu    
   x                           tq> DEFERRABLE qqqqqu            x    
   x                           mq> NOT DEFERRABLE qj            x    
   mq> INITIALLY DEFERRED qqqqqwqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqj    
                               mq> DEFERRABLE qqqqqj                 

  (B)0sql-and-dtr-clause =                                             
                                                                   
  qwq> QUERY HEADER IS qw> <quoted-string> wqqqqqqqqqqqqqqqqqqqwq> 
   x                    mqqqqqq / <qqqqqqqqj                   x   
   tq> EDIT STRING IS <quoted-string> qqqqqqqqqqqqqqqqqqqqqqqqqu   
   x                                                           x   
   tq> QUERY NAME FOR qwq> DTR qqqqqqqqwq> IS <quoted-string> qu   
   x                   mq> DATATRIEVE qj                       x   
   mq> DEFAULT VALUE FOR qwq> DTR qqqqqqqqwq> IS literal   qqqqj  
                          mq> DATATRIEVE qj                        
                                                                   

  (B)0table-constraint =                               
                                                   
  qqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqk    
     mq> CONSTRAINT <constraint-name> qqqj    x    
   lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj    
   mqq> table-constraint-clause qqqqqqqqqqqqqqk    
   lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj    
   mqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqq> 
       mq> constraint-attributes qqj               
                                                   

  (B)0table-constraint-clause =                           
                                                      
  qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq>
   tq> PRIMARY KEY q> ( qw> <column-name> wq> ) qqu   
   x                     mqqqqqqq , <qqqqqj       x   
   tq> UNIQUE q> ( qw> <column-name> wq> ) qqqqqqqu   
   x                mqqqqqqq , <qqqqqj            x   
   tq> CHECK (predicate) qqqqqqqqqqqqqqqqqqqqqqqqqu   
   mq> FOREIGN KEY q> ( qw> <column-name> wq> ) k x   
                         mqqqqqqq , <qqqqqj     x x   
     lqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqj x   
     mq> references-clause qqqqqqqqqq>qqqqqqqqqqqqj   
                                                      
Close Help