TRUNCATE

Applies to: ❌ Data 360 SQL ✅ Tableau Hyper API

Empty a table.

Syntax 

 
1TRUNCATE [ TABLE ] <name>

Description 

TRUNCATE removes all rows from a table. It has the same effect as an unqualified DELETE on the target table. It is just used as a convenience statement.

Parameters 
<name>

The name (optionally schema-qualified) of a table to truncate.

Examples 

Truncate the table bigtable:

1TRUNCATE bigtable;

Data 360 REST API Reference
Data 360 SQL Reference
Data 360 SQL and Tableau Hyper API
Data 360 SQL Syntax
Data Types
Scalar Functions
Aggregate Functions
Window Functions
Set Returning Functions
SQL Commands for Tableau Hyper API
External File Support
INSERT
UPDATE
DELETE
TRUNCATE
COPY FROM
COPY TO
CREATE DATABASE
CREATE SCHEMA
CREATE TABLE
CREATE TABLE AS
CREATE EXTERNAL TABLE
ALTER SCHEMA
ALTER TABLE
DROP TABLE
DROP SCHEMA
DROP DATABASE
EXPLAIN
PREPARE
EXECUTE
DEALLOCATE

DID THIS ARTICLE SOLVE YOUR ISSUE?
Let us know so we can improve!