KFAA30629-E


      
         You cannot use the ALTER TABLE statement to delete a column. <SQLSTATE:53021>

         
            
               aa....aa: Reason why columns cannot be deleted

               
                  
                     
                        the segment for storing the row has been allocated to the table or an operation is performed after the column is added that prevents the column from being deleted:

                        Either of the following conditions that allows deletion of a row are not met.

                        
                           
                              The segment that stores the rows is not assigned to the base table that deletes the rows.

                           

                           
                              The column to be deleted is a column added with a ALTER TABLE statement, and no process (such as an INSERT statement or adbimport command) was executed after the column was added that would prevent the column from being deleted

                           

                        

                     

                  

               

            
            
               S:

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

               

            
            
               Action:

               
                  See Deleting a column after deleting all rows in a base table in Deleting columns of a base table in the manual HADB Setup and Operation Guide and delete the column.