History Table Views
- Last UpdatedMar 10, 2025
- 1 minute read
Views have been created for the extension tables to make querying these tables easier. Normally, you must use the full reference for an extension table in the query, which is linked_server.catalog.schema.objectname. An extension table view allows you to simply use the view name instead, eliminating the need to provide the long reference.
All of the following views reflect the same table structure as the extension tables after which they are named.
|
This view |
References this extension table |
|---|---|
|
History |
INSQL.Runtime.dbo.History |
|
HistoryBlock |
INSQL.Runtime.dbo.HistoryBlock |
|
Live |
INSQL.Runtime.dbo.Live |
|
AnalogSummaryHistory |
INSQL.Runtime.dbo.AnalogSummaryHistory |
|
StateSummaryHistory |
INSQL.Runtime.dbo.StateSummaryHistory |
Note: Some History table views are included in the database for backward compatibility support only. It is recommended that you discontinue the use of these views, as they will be dropped in a future release. For details about History table views retained for backward compatibility, see History Table Views (Backward Compatible).