truncate table (extension using where 1=1)

Description

Removes all rows from a table.

Syntax

Transact-SQL Syntax

truncate table [[database.]owner.]table_name

ODBC Syntax

Not supported.

The command can be transformed into an equivalent delete command as follows:

DELETE FROM table_name

Parameters

table_name

is the name of the table to be truncated.

Examples

Example 1

truncate table authors

Usage

ASE/CIS passes the command to the DirectConnect server as a language event.