Help Centre › Building Processes
Check if a table exists in the database.
Add it to a process
In the process designer, open the Add step tab. Find Check if table exists under Database › Schema, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| Variable | Yes | Name of the variable where the result will be stored Default: exists. |
| Connection name | Yes | Connection name |
| Table name | Yes | The database table name |
| Schema | No | The database schema name |
What it gives back
{exists}– True if table exists
See all Database steps.
Errors
| Error | Description |
|---|---|
| Connection not found | No open connection exists with the specified name |
Tips
- Check before CREATE TABLE or INSERT operations to avoid errors
- Use in combination with conditional logic to create tables on first run