SQL$HELP72.HLB  —  ALTER  TABLE  Format
  (B)0ALTER TABLE qq> <table-name> qk                              
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj                              
  mqwqwq> ADD qwq> COLUMN col-definition qqqqqqqqqqqqqqqqwqwq>
    x x        tq> CONSTRAINT table-constraint qqqqqqqqqqu x   
    x x        mq> ( qwq> col-definition qwq> ) qqqqqqqqqu x
    x x               mqqqqqqq , <qqqqqqqqj              x x
    x tq> ALTER COLUMN qq> alter-col-definition qqqqqqqqqu x   
    x tq> MODIFY q> ( qwq> alter-col-definition qqwq> ) qu x
    x x                mqqqqqqqqqqqq , <qqqqqqqqqqj      x x
    x tq> DROP qwq> COLUMN <column-name> qqqqqqqqqqqqqqqqu x   
    x x         mq> CONSTRAINT <constraint-name> qqqqqqqqu x   
    x tq> enable-clause qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x   
    x tq> disable-clause qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x  
    x tq> RENAME TO <new-table-name> qqqqqqqqqqqqqqqqqqqqu x
    x mq> COMMENT IS qw> '<quoted-string>' qwqqqqqqqqqqqqj x
    x                 mqqqqq / qqqqqqqqqqqqqj              x
    mqqqqqqqqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqqqqj

  (B)0col-definition =                                             
                                                               
  qq> <column-name> qqk                                        
      lqqqqqqqqqqqqqqqj                                        
      tq> add-column-type qwqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwqk  
      x                    tq> DEFAULT value-expr  qqqqu x x   
      x                    mq> column-identity   qqqqqqj x x
      mqqq> COMPUTED BY value-expr qqqqqqqqqqqqqqqqqqqqqqj x  
      lqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqj 
      mqqwqqqqqqqqqqqqqqqqqqqwwqqqqqqqqqqqqqqqqqqqqwqqqqqqqk
         mq> col-constraint qjmq> position-clause qj       x
      lqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqj
      mqqwqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqq>
         mq> sql-and-dtr-clause qqj

  (B)0add-column-type =

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

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

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

  (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)0references-clause =                              
                                                   
  qq> REFERENCES <referenced-table-name> qk            
       lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj            
       mqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq> 
         mq> ( qw> <referenced-column-name> wq> ) qj   
                mqqqqqqqqqqq , <qqqqqqqqqqqqj          

  (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)0position-clause =                            
                                               
  qwq> AFTER qqwqq> COLUMN <column-name> qqqq> 
   mq> BEFORE qj                               

  (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   
                                                      

  (B)0alter-col-definition =                                                
                                                                        
  q> <column-name> wqqqqqqqqqqqqqqqqwwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwk
                   mq> alt-col-type jtq> SET DEFAULT value-expr qqqux    
                                     tq> DEFAULT value-expr qqqqqqqux    
                                     mq> DROP DEFAULT value-expr qqjx    
  lqqqqqqqqqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj   
  mqwqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqwqqqqqqqqk    
    mwq> col-constraint qwqj         mq> position-clause qj        x    
     mqqqqqqqq <qqqqqqqqqj                                         x    
  lqqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj    
  mqwqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqq> qqqqqqqqqqqqqqqqqqwqwqqqqqqqqqq>  
    x tqq> sql-and-dtr-clause qqqqqqqqqqqqqqqqqqqqqqqqqqu x             
    x tqq> NO QUERY HEADER qqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x             
    x tqq> NO EDIT STRING qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x             
    x tqq> NO QUERY NAME qqqqwq> FOR qqwq> DTR qqqqqqqqwj x             
    x mqq> NO DEFAULT VALUE qj         mq> DATATRIEVE qj  x             
    mqqqqqqqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqqqqj             

  (B)0alt-col-type =

  qwq> data-type qqqqqqqqqqqqqqqqqqqwqwqqqqqqqqqqqqqqqqqqqqqwqwqq> 
   tq> <domain-name>  qqqqqqqqqqqqqqj mq> column-identity qqj x
   tq> COMPUTED BY value-expr qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
   mq> AUTOMATIC qwqqqqqqqqqqqqwqqqq> AS value-expr qqqqqqqqqqj
                  tq> INSERT qqu
                  mq> UPDATE qqj

  (B)0enable-clause =                                                
                                                                 
  qq> ENABLE qqqk
  lqqqqqqq<qqqqqj
  mqwq> ALL TRIGGERS qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>
    tq> TRIGGER <trigger-name> qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwj
    mqwqqqqqqqqqqqqqqqwqwq> ALL CONSTRAINTS qqqqqqqqqqqqqqqqqqqqqqwj  
      tq> VALIDATE qqqu tq> CONSTRAINT <constraint-name> qqqqqqqqqu   
      mq> NOVALIDATE qj tq> PRIMARY KEY qqqqqqqqqqqqqqqqqqqqqqqqqqu   
                        mq> UNIQUE q>( qwq> <column-name> qwq> ) qj   
                                        mqqqqqqq , <qqqqqqqj          
                                                                       

  (B)0disable-clause =                                               
                                                                 
  qq> DISABLE qqqwq> ALL TRIGGERS qqqqqqqqqqqqqqqqqqqqqqqqqwqq>  
                 tq> TRIGGER <trigger-name> qqqqqqqqqqqqqqqu     
                 tq> ALL CONSTRAINTS qqqqqqqqqqqqqqqqqqqqqqu     
                 tq> CONSTRAINT <constraint-name> qqqqqqqqqu     
                 tq> PRIMARY KEY qqqqqqqqqqqqqqqqqqqqqqqqqqu     
                 mq> UNIQUE q>( qwq> <column-name> qwq> ) qj     
                                 mqqqqqqq , <qqqqqqqj            
Close Help