KFAA31658-E


      
         The DROP INDEX statement cannot be used to delete the B-tree indexes that correspond to the primary key.

         Also, the DROP INDEX
            statement cannot be used to delete the range indexes that are automatically defined for
            archive range columns. <SQLSTATE: 42IB0>

         
            
               aa....aa: Index that was attempted to be
                  deleted

               
                  
                     
                        the primary
                           key: B-tree index corresponding to the primary
                           key

                     

                     
                        an archive
                           range column: Range
                           index automatically defined for an archive range column

                     

                  

               

            
            
               S: 

               
                  Ignores this SQL statement. Alternatively, the system invalidates this transaction.

               

            
            
               Action:

               
                  To delete the B-tree indexes that correspond to the primary key, use the DROP TABLE statement to delete them for each base table.

                  To delete the range indexes automatically defined for archive range
                     columns, use the DROP TABLE
                     statement to delete the base table for the range indexes.