Is it possible to drop a column in a table which contains only one column? How?
- 1 Answers
- 3333 Views
- I also Faced
- E-Mail Answers
Answer Posted / eshwer
No, its not possible to drop all columns.
CREATE TABLE T2(A NUMBER(2));
table T2 created.
alter table
T2
drop column
A;
Error report:
SQL Error: ORA-12983: cannot drop all columns in a table
12983. 00000 - "cannot drop all columns in a table"
*Cause: An attempt was made to drop all columns in a table.
*Action: Make sure at least one column remains in the table after
the drop column operation.
SELECT * FROM T2;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
