KFAA30695-E


      
         An SQL statement was executed with RESTRICT
            specified for the drop behavior, but the SQL statement resulted in an error for one of
            the following reasons. <SQLSTATE: 42I44>

         
               An attempt was made to delete base tables for which indexes or
                  constraints were defined.

            
               An attempt was made to delete schemas for which tables were defined.

            
               An attempt was made to delete a table on which viewed tables depend.

            
Note

            Because range indexes are always defined for archivable multi-chunk tables,
               deleting an archivable multi-chunk table results in error for reason 1 above.

         
               aa....aa: SQL statement that caused the error

               
                        table: DROP TABLE statement

                     
                        schema: DROP SCHEMA statement

                     
                        viewed table: DROP VIEW statement

                     
               bb....bb: Resource that is defined

               
                        table: Table

                     
                        index: Index

                     
                        viewed table: Viewed table

                     
                        constraint: Constraint

                     
               S: 

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

               
               Action:

               
                  Make sure that no problems occur if tables, indexes, or constraints
                     are deleted (or viewed tables are deleted or invalidated) during execution of
                     the DROP TABLE statement,
                     DROP SCHEMA statement, or
                     DROP VIEW statement. If
                     there are no problems, re-execute the SQL statement with CASCADE specified for the drop behavior or without specifying the drop
                     behavior.