> ## Documentation Index
> Fetch the complete documentation index at: https://docs.revoengine.com/llms.txt
> Use this file to discover all available pages before exploring further.

# api.truncateDatabase()

> Public low-code contract, signatures and examples for api.truncateDatabase.

## `api.truncateDatabase()`

Removes all rows from a logical database selected by name.

Notes:

* Unavailable with `readOnly: true` (throws an error).
* TRUNCATE does not create row audit events, even when database audit is enabled.
* Use an ordinary filtered delete, such as primary key IS NOT NULL, to preserve row audit events.
* Identity counters are preserved by default.
* Set restartIdentity only when generated key reuse is explicitly intended.

### Signature

```ts theme={null}
static truncateDatabase(
      name: string,
      options?: TruncateDatabaseOptions,
    ): Promise<void>;
```

### Example

```ts theme={null}
await api.truncateDatabase('orders', { restartIdentity: false });
```

See [all api methods](https://docs.revoengine.com/low-code/reference/api.md) or [runtime basics](https://docs.revoengine.com/low-code/overview.md).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.