Query user_unused_col_tabs : user_unused_col_tabs « System Tables Views « Oracle PL / SQL






Query user_unused_col_tabs

 


create table people(
  employee_id     number(9),
  first_name      varchar2(15),
  last_name       varchar2(20),
  email           varchar2(25),
  constraint pk_people primary key (employee_id)
);

insert into people values (1, 'T', 'Kyte', 'Y@q.com');

insert into people values (2, 'S', 'Viper','s@q.com');

insert into people values (3, 'C', 'Beck', 'c@q.com');


alter table people drop column first_name;

alter table people drop column last_name;

select * from user_unused_col_tabs;

ALTER TABLE people DROP UNUSED COLUMNS;

drop table people;

 








Related examples in the same category