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

AVEVA™ Historian

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).

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