Drop a table demo : Drop Table « Table « Oracle PL / SQL

1. Oracle PL / SQL
2. Table
3. Drop Table

Drop a table demo

  
SQL>
SQL> create table drop_me(
  2       a   int,
  3       b   int
  4  );

Table created.

SQL>
SQL> insert into drop_me values ( 1, 1 );

1 row created.

SQL>
SQL> insert into drop_me values ( 1, 2 );

1 row created.

SQL>
SQL> insert into drop_me values ( 2, 1 );

1 row created.

SQL>
SQL> drop table drop_me;

Table dropped.

SQL>
SQL>

           
         
    
  

Related examples in the same category