Get Started

SQL COMMANDS

Truncate Command

CONSTRAINTS

NOT NULL

SQL FUNCTIONS

STRING FUNCTION

NUMERIC FUNCTION

PL/SQL

ADVANTAGES OF PL/SQL

DATATYPES AND DECLARATION

VARIABLES AND CONSTANTS

CONTROL STATEMENTS

ITERAIVE CONTROL

CONDITIONAL CONTROL

ERROR HANDLING

OVERVIEW OF ERROR HANDLING

EXCEPTION TYPES

DATATYPES AND DECLARATION

SUBPROGRAMS

INTRODUCTION

DATABASE TRIGGERS

ERROR WITH TRIGGERS

The SQL Drop TABLE Statement

The DROP TABLEstatement is used to drop an existing table in a database.

Syntax


DROP OBJECTNAME TABLENAME;

Output

create table

The table name specify the name of the table