History Table Views (Backward Compatible)
- Last UpdatedMar 18, 2021
- 1 minute read
The following views reflect the same table structure as the extension tables for which they are named.
|
These views |
Reference this extension table |
|---|---|
|
AnalogHistory, v_AnalogHistory |
INSQL.Runtime.dbo.AnalogHistory |
|
AnalogLive, v_AnalogLive |
INSQL.Runtime.dbo.AnalogLive |
|
DiscreteHistory, v_DiscreteHistory |
INSQLD.Runtime.dbo.DiscreteHistory |
|
DiscreteLive v_DiscreteLive |
INSQLD.Runtime.dbo.DiscreteLive |
|
v_History |
INSQL.Runtime.dbo.History |
|
v_HistoryBlock |
INSQL.Runtime.dbo.HistoryBlock |
|
v_Live |
INSQL.Runtime.dbo.Live |
|
StringHistory, v_StringHistory |
INSQL.Runtime.dbo.StringHistory |
|
StringLive, v_StringLive |
INSQL.Runtime.dbo.StringLive |
To allow joins between the analog, string, and discrete tables, the analog and string views reference the OLE DB linked server "INSQL," while the discrete views reference the OLE DB linked server "INSQLD."
Note: In SQL Server Management Studio, the extension tables are listed under the INSQL or INSQLD linked servers under the Server objects tree item.