Cause :- When you want to drop all column from a table you get this error. Table must remain at least one or more column.
SQL> CREATE TABLE TEST_COLUMN(ID NUMBER);
Table created.
SQL>
SQL> ALTER TABLE TEST_COLUMN DROP COLUMN ID;
ALTER TABLE TEST_COLUMN DROP COLUMN ID
*
ERROR at line 1:
ORA-12983: cannot drop all columns in a table
SQL>
SQL> CREATE TABLE TEST_COLUMN(ID NUMBER);
Table created.
SQL>
SQL> ALTER TABLE TEST_COLUMN DROP COLUMN ID;
ALTER TABLE TEST_COLUMN DROP COLUMN ID
*
ERROR at line 1:
ORA-12983: cannot drop all columns in a table
SQL>
No comments:
Post a Comment