# Types of system SQL templates

This section gives detail information related to the different types of the pre-defined SQL templates.

Even though the statements of each group of templates vary from database to database, according to the operations they are intended to accomplish, they are also grouped on the basis of their types in each folder.

The below table provides these types and their related information.

| Name | Function | Associated components | Required component parameters |
| --- | --- | --- | --- |
| Aggregate | Realizes aggregation (sum, average, count, etc.) over a set of<br>data. | tSQLTemplateAggregate | Database name<br><br>Source table name<br><br>Target table name |
| Commit | Sends a Commit instruction to RDBMS. | tSQLTemplate<br>tSQLTemplateAggregate<br>tSQLTemplateCommit<br>tSQLTemplateFilterColumns<br>tSQLTemplateFilterRows<br>tSQLTemplateMerge<br>tSQLTemplateRollback | None |
| Rollback | Sends a Rollback instruction to RDBMS. | tSQLTemplate<br>tSQLTemplateAggregate<br>tSQLTemplateCommit<br>tSQLTemplateFilterColumns<br>tSQLTemplateFilterRows<br>tSQLTemplateMerge<br>tSQLTemplateRollback | None |
| DropSourceTable | Removes a source table. | tSQLTemplate<br>tSQLTemplateAggregate<br>tSQLTemplateFilterColumns<br>tSQLTemplateFilterRows | Table name (when use tSQLTemplate)<br><br>Source table<br>name |
| DropTargetTable | Removes a target table. | tSQLTemplateAggregate<br>tSQLTemplateFilterColumns<br>tSQLTemplateFilterRows | Target table name |
| FilterColumns | Selects and extracts a set of data from given columns in RDBMS. | tSQLTemplateAggregate<br>tSQLTemplateFilterColumns<br>tSQLTemplateFilterRows | Target table name (and schema)<br><br>Source table name (and<br>schema) |
| FilterRow | Selects and extracts a set of data from given rows in RDBMS. | tSQLTemplateAggregate<br>tSQLTemplateFilterColumns<br>tSQLTemplateFilterRows | Target table name (and schema)<br><br>Source table name (and<br>schema)<br><br>Conditions |
| MergeInsert | Inserts records from the source table to the target table. | tSQLTemplateMerge<br>tSQLTemplateCommit | Target table name (and schema)<br><br>Source table name (and<br>schema)<br><br>Conditions |
| MergeUpdate | Updates the target table with records from the source table. | tSQLTemplateMerge<br>tSQLTemplateCommit | Target table name (and schema)<br><br>Source table name (and<br>schema)<br><br>Conditions |