The ClearSCADA database consists of a series of pre-configured tables. Each table contains fields from the classes that form the table.

To reference a database field in SQL, you reference the column that represents that field in the relevant database table. You can reference both data and configuration fields. In each case, the column reference comprises the data type of the database field that the column represents (see Data Types).


In an SQL query, a column can comprise:


ClearSCADA 2017 R2