SQL Tutorial


SQL CREATE TABLE
SQL DROP TABLE
SQL TRUNCATE TABLE
SQL INSERT INTO
SQL UPDATE
SQL DELETE FROM







Data Warehousing & Business Intelligence
Area Codes Info
State Info
HTML Tutorial














Home
SQL Commands
Table Manipulation
SQL Syntax

SQL TRUNCATE TABLE

Sometimes we wish to get rid of all the data in a table. One way of doing this is with DROP TABLE, which we saw in the last section. But what if we wish to simply get rid of the data but not the table itself? For this, we can use the TRUNCATE TABLE command. The syntax for TRUNCATE TABLE is

TRUNCATE TABLE "table_name"

So, if we wanted to truncate the table called customer that we created in SQL CREATE, we simply type

TRUNCATE TABLE customer.

Next Section

Site Map   |   Resources

1