Background documentation-7023: Dropping of all columns not allowed Locate this document in the navigation structure

 

Explanation

You have attempted to drop all the columns in a table. This is not allowed.

User Response

  1. Delete the table using the DROP TABLE statement. This deletes all view tables, privileges, indexes, referential CONSTRAINT definitions, and so on that depend on this table.

  2. Afterwards, use the CREATE TABLE statement to define a new table with the same name.