|
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 TABLE, we simply type,
TRUNCATE TABLE customer
SQL INSERT >>
Copyright 1999-2008 1keydata.com. All Rights Reserved. Privacy Policy
|
