# Example

If you want to create five tables (tab1, tab2, tab3, tab4, and tab5), you could create a transformation similar to this one:

![Execute SQL Script Example](https://2745965000-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvZoINBz5C5WnDZQlbOJQ%2Fuploads%2Fgit-blob-15e3fde47bb332fc86678a019c6ddad87307800a%2FPDI_TransStep_Execute_SQL_Script_Example.png?alt=media)

The SQL script to execute might look like this:

```sql
CREATE TABLE tab?
(
a INTEGER
);
```

The field name to specify as the parameter is then the "count" sequence defined in the second step.

**Note:** The execution of the transformation will halt when a statement in the script fails.

As an extra option, you can return the total number of inserts (`INSERT INTO` statements), updates (`UPDATE` table), deletes (`DELETE FROM` table) and reads (`SELECT` statements) by specifying the field names in the lower right of the dialog box.