Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Historian

SQLTemplate

  • Last UpdatedMar 10, 2025
  • 1 minute read

Contains one row for each pre-defined SQL script, which can be copied and used as a basis for an event detection or action script.

Column

Data Type

Description

(PK) TemplateKey

int NOT NULL

The unique numerical identifier for a SQL template. This value is automatically generated when a new SQL template is created.

Description

nvarchar(50) NULL

The description of the SQL template.

Type

int NULL

The type of SQL template. 0 = Detector; 1 = Action.

Script

ntext NULL

A pre-defined SQL script. This script can be copied and used as an event detection or action script.

Related Links
TitleResults for “How to create a CRG?”Also Available in