Truncate Tables
Description
Truncate Tables is a Process Entry in the Utilities plugin for Process Studio Processes. This process entry allows you to truncate one or several tables at once without writing any SQL command.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Process Entry name | Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name. |
| 2 | Connection | Name of the database connection on which the tables reside. Use "Edit..." and "New..." to edit and/or create a new connection. |
| 3 | Previous results to args? | Check this option if you want to get in a dynamic way tables to truncate from results of previous process entry. Note: The first field has to be the table name and the second one the schema (leave it Null if it's not needed). |
| 4 | Click here to return tables name list | This button will return all tables defined on the connection. Select tables (one or several) and press "OK". Tables name will be automatically added to "Selected tables" grid. |
| 5 | Selected tables grid | Specify here the tables to truncate (insert it manually or use the previous button). If the table is in a different schema that the default one, please specify the schema name. |
| 6 | Delete | Remove entries from grid (select one several entries and click on this button to remove it). |
| 7 | OK | Click on this button to save process entry settings changes |
| 8 | Cancel | Discard process entry settings changes |