urQL/docs/09-truncate-table.md

# TRUNCATE TABLE

Removes all rows in a base table.

```
<truncate-table> ::=
  TRUNCATE TABLE [ <ship-qualifier> ] <table>
  [ <as-of-time> ]
```

### API
```
+$  truncate-table
  $:
    %truncate-table
    table=qualified-object
    as-of=(unit as-of)
  ==
```

### Arguments

**`<table>`**
The target table.

**`<as-of-time>`**
Timestamp of table creation. Defaults to `NOW` (current time). When specified, the timestamp must be greater than both the latest database schema and content timestamps.

### Remarks

The command potentially mutates `<table>`, resulting in a state change of the Obelisk agent.

Tables in the *sys* namespace cannot be truncated.

### Produced Metadata

Row count (when table was populated)
Content timestamp

### Exceptions

state change after query in script
database `<database>` does not exist
namespace %ns1 does not exist
`<table>` as-of data time out of order
`<table>` as-of schema time out of order
table `<table>` does not exist in `<namespace>`
`GRANT` permission on `<table>` violated