Saturday, January 6, 2018

Drop Structure


Column Drop (be Carefull) 

alter table table_name drop column col_name1;  --one column table
/
alter table table_name drop(col_name1, col_name2)  --more columns in table 

--------------------

alter table APPLPATH12c drop column FOLDER;

/

alter table APPLPATH12c drop (IP3,IP2);  

No comments:

Post a Comment

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/