Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > TRUNCATE (IDS) > 4 4 4

The TABLE Keyword

4

The TABLE keyword has no effect on this statement, but it can be included 4to make your code more legible for human readers. Both of the following statements 4have the same effect, deleting all rows and any related index data from the customer table:

4
TRUNCATE TABLE customer
4
4TRUNCATE customer
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]