The modTemplates Table
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
The modTemplates table is a directory table for all the templates registered on the server. It holds a number of key attributes associated with each template. Its primary role is to provide the information required by the Workflow Manager for SQL Server. The link to each template in the database is implemented by storing the table ID of the template from sysObjects in the table_id column.
Some of the modTemplates columns, such as Name, Caption, and Version, have their values replicated from template attributes stored in the template header, which is the primary storage for those values. They are copied into the modTemplates table to optimize the display of the template list. Workflow Designer for SQL Server administration tools, such as the template wizards and the Workflow Manager, keep this information synchronized.
**Note **You should not alter the modTemplates table manually. Use the Workflow Designer for SQL Server and the Workflow Manager to make changes. Schema integrity is not guaranteed if you make manual changes to any system tables.
The following table lists the modTemplates columns and their data types and provides a brief description of each.
| Column | Data type | Description |
|---|---|---|
| Id | identity (int) | Unique identifier for each template. |
| Name | nvarchar(128) | Name of the template (for example "IssuesAction"). |
| Caption | nvarchar(256) | Friendly name of the template displayed as the template title in the Workflow Manager. |
| Version | nchar(10) | Template version in dd.dd.dddd format. |
| Table_id | int | ID of the template table in the system database. |
| Available | bit | If 0, the template cannot be deployed. This column makes it possible for an administrator to install a template but not make it available. It is a way to hide the template from all users. |
| Description | ntext | Text describing the template. This information is entered when using the SQL Server Workflow Template Creation wizard. |
See Also
ModSystem Database Tables | The modApplications Table | The Individual Template Tables | The modUserList Table | The modProperties Table (modSystem Database)