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 TRUNCATE Statement

The TRUNCATE TABLE command deletes the data inside a table, but not the table itself.

Syntax


TRUNCATE OBJECTNAME TABLENAME;

Output

create table

The column parameters specify the names of the columns of the table.

The datatype parameter specifies the type of data the column can hold (e.g. varchar, integer, date, etc.).