Restrictions

The TRUNCATE statement fails if any of the following conditions exist:

• One or more cursors are open on the table.
• Referential constraints exist on the table and any of the referencing tables has at least one row.
• A shared or exclusive lock on the table already exists.
• The statement references a view.
• The statement references any of the following types of tables:
  • An external table
  • A system catalog table
  • A violations table
• The statement is issued within a transaction.