Do Ingres and Vectorwise Databases support functionality similar to TRUNCATE table in SQL Server? If so, what is the syntax?

135 views Asked by At

Trying to find if there is something similar to TRUNCATE TABLE in these 2 database systems.

1

There are 1 answers

0
PaulM On
MODIFY mytable TO TRUNCATED

is the equivalent SQL for Ingres/Vector/ActianX