DROP Table Statement in Oracle

Table of Contents

DROP statement is used to do below operations:

We have an existing table called EMP_ALTER_TAB with below definition:

DROP Table Statement in Oracle : output

ALTER TABLE EMP_ALTER_TAB DROP(JOB_ID);

DESC EMP_ALTER_TAB;

ALTER TABLE EMP_ALTER_TAB DROP COLUMN LAST_NAME;

DESC EMP_ALTER_TAB;

ALTER TABLE EMP_ALTER_TAB DROP(HIREDATE,
                               SALARY,
                               DEPARTMENT_ID);

DESC EMP_ALTER_TAB;

DROP TABLE EMP_ALTER_TAB;

SELECT TABLE_NAME, 
       TABLESPACE_NAME, 
       STATUS, 
       NUM_ROWS, 
       TABLE_LOCK
FROM USER_TABLES
WHERE TABLE_NAME = 'EMP_ALTER_TAB';

RELATED TOPICS:

Author