• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / statement / DROP TABLE Statement in Oracle SQL – PLSQL

DROP TABLE Statement in Oracle SQL – PLSQL

October 22, 2012 by techhoneyadmin

The DROP TABLE statement in PLSQL allows us to delete or drop a table from the database.

It is a Data Definition Language (DDL) statement.

Syntax for the DROP TABLE statement in PLSQL is:

DROP TABLE table_name;

Let’s take an example for understanding:

Suppose have a table named “Employee” as shown below in database.

Employee_ID Employee_Name Salary Department Commission
101 Emp A 10000 Sales 10
102 Emp B 20000 IT 20
103 Emp C 28000 IT 20
104 Emp D 30000 Support
105 Emp E 32000 Sales 10

If we want to delete the ’employee’ table from the database we use the DROP TABLE statement as follows:

DROP TABLE employee;

The above statement will delete the table ’employee’ from the database.


Filed Under: statement Tagged With: drop table statement in oracle plsql, drop table statement in oracle sql, DROPTABLEPLSQL, how to use drop table statement in oracle database query, how to use drop table statement in oracle plsql, how to use drop table statement in oracle sql, syntax and example of drop table statement in oracle database query, syntax and example of drop table statement in oracle plsql, syntax and example of drop table statement in oracle sql, using drop table statement in oracle database query, using drop table statement in oracle plsql, using drop table statement in oracle sql

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in