Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-12983

cannot drop all columns in a table

Cause

An attempt was made to drop all columns in a table. A table must have at least one column. If you want to remove the entire table, use the DROP TABLE command instead.


Action

Ensure that at least one column remains in the table after the DROP COLUMN operation.