Show TOC

-7023: Dropping of all columns not allowedLocate this document in the navigation structure

Use

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.