SQL$HELP72.HLB  —  CREATE  TABLE  Format
  (B)0 CREATE qwqqqqqqqqqqqqqqqqqqqqqqqqqqqwq> TABLE qqqqqqqqk    
           tq> INFORMATION qqqqqqqqqqqqu                 x    
           tq> GLOBAL qwq> TEMPORARY qqj                 x    
           mq> LOCAL qqj                                 x    
  lqqqqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj    
  mwq> FROM <path-name> qwqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqk
   x                     mq> ALIAS <alias> qqj                       x
   mq> <table-name> qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq> table-body qu
                     mq> STORED NAME IS stored-name qj               x   
    lqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
    mqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>
      mqwqq> create-table-attributes qwj
        mqqqqqqqqqqqqqqq<qqqqqqqqqqqqqj

  (B)0create-table-attributes =

  qqqwq> COMMENT IS qqwq> 'quoted-string' qwqqqqqqwq>  
     x                mqqqqqqqq / qqqqqqqqqj      x
     tq> COMPRESSION IS qwq> ENABLED qqqwqqqqqqqqqu      
     x                   mq> DISABLED qqj         x      
     tq> DISABLE qqwq> cre-enable-disable qqqqqqqqu      
     tq> ENABLE qqqj                              x
     tq> LOGGING qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu      
     tq> NOLOGGING qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu 
     mq> ON COMMIT qwq> DELETE qqqqwq> ROWS qqqqqqj
                    mq> PRESERVE qqj

  (B)0table-body =                                                  
                                                                
  qwq> (column-constraint-list) qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>
   x                                                             x
   mq> LIKE <other-table-name> qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwj
                                 mqq> (column-constraint-list) qj
                                                                

  (B)0cre-enable-disable =                         
                                               
  qwq> ALL CONSTRAINTS qqqqqqqqqqqqqqqqqqqqqwq>
   tq> CONSTRAINT <constraint-name> qqqqqqqqu  
   tq> PRIMARY KEY qqqqqqqqqqqqqqqqqqqqqqqqqu  
   mq> UNIQUE ( qwq <column-name> wq> ) qqqqj  
                 mqqqqqqq , <qqqqqj            

  (B)0
  col-definition =                                              
                                                                
  qq> <column-name> qqk                                         
      lqqqqqqqqqqqqqqqj                                         
      tqqq> column-type qqqwqqqqqqqqqqqqqqqqqqqqqqqqqqwqwqqk    
      x                    tq>DEFAULT   value-expr    x x  x    
      x                    mq>column-identity qqqqqqqqj x  x
      mqqq> COMPUTED BY value-expr qqqqqqqqqqqqqqqqqqqqqj  x
      lqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqj  
      mqwqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqqqqqk
        mq> col-constraint qqj                x
      lqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqj
      mwqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqwqqqqqqqqqqqqqqqqqqqqqqqwq>
       mq> comment-is-clause  qqj     mq> sql-and-dtr-clause qj     
        
        
                                                                

  (B)0column-constraint-list =                
                                          
  qqwqqwq> col-definition qqqqqqqwqqqqqwq>
    x  mq> table-constraint qqqqqj     x
    mqqqqqqqqqqqqqqqq , <qqqqqqqqqqqqqqj  

  (B)0column-identity =                                           
                                                              
  qq> IDENTITY qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq> 
                 mq ( <start-with> qqwqqqqqqqqqqqqqqqqqqqqqqwq> ) qqj
                                     mq> , <increment-by> qqj
                                                       

  (B)0column-type=         

  qqwq> data-type qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq>
    tq> <domain-name> qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
    tq> references-clause qqqqqqqqqqqqqqqqqqqqqqqqqqqu
    mq> AUTOMATIC qqwqqqqqqqqqqqwqq> AS value-expr qqj
                    tq> INSERT qu
                    mq> UPDATE qj

  (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)0col-constraint=                          
                                           
   qqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwk 
      mq> CONSTRAINT <constraint-name> qjx 
    lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj 
    tq> PRIMARY KEY qqqqqqqqqqqqqqqqqk     
    tq> UNIQUE qqqqqqqqqqqqqqqqqqqqqqu     
    tq> NOT NULL qqqqqqqqqqqqqqqqqqqqu     
    tq> NULL qqqqqqqqqqqqqqqqqqqqqqqqu
    tq> CHECK (predicate) qqqqqqqqqqqu     
    tq> references-clause qqqqqqqqqqqu     
    mqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqqqu     
    lqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqj     
    mqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq> 
         mqq> constraint-attributes qqj    

  (B)0references-clause =                              
                                                   
  REFERENCES <referenced-table-name> qk            
   lqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqj            
   mqwqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqqqwq> 
     mq> ( qw> <referenced-column-name> wq> ) qj   
            mqqqqqqqqqqq , <qqqqqqqqqqqqj          
                                                   

  (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)0literal =                       
                                  
  qqwq> numeric-literal qqqqwqqq> 
    tq> string-literal qqqqqu     
    tq> date-time-literal qqu     
    tq> interval-literal qqqu     
    mq> dbkey-literal qqqqqqj     

  (B)0table-constraint =                              
                                                  
  qqqwqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqqwqqqqk   
     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> ( qwq> <column-name> qw> ) qu   
   x                     mqqqqqqq , <qqqqqqqj     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   
     lqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqj x   
     mq> references-clause qqqqqqqqqqqqq>qqqqqqqqqj   
                                                      

  (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                 
Close Help