Tables
- Last UpdatedMar 10, 2025
- 1 minute read
All information regarding how the system is configured is stored in tables in the Runtime database. Event history, summary history, and summary data are also stored in SQL Server tables. You can view the details of all tables by using the Microsoft SQL Server Management Studio.
Related Links
- _AutoIntervalReplicationSchedule
- _AutoReplicationGroup
- _AutoReplicationRule
- _AutoReplicationSchedule
- _AutoReplicationServer
- _AutoReplicationTagEntity
- _AutoTag
- _AutoTagHistory
- _DeletedReplicationTagExtendedProperty
- _EventTag
- _IODriver
- _IOServer
- _ReplicationTagExtendedProperty
- _Tag
- _TagExtendedProperty
- _Topic
- aaAreaData
- aaAreaXML
- aaAttributeData
- aaAttributeDataPending
- aaObjectData
- aaObjectDataPending
- ActionType
- AnalogSnapshot
- AnalogSummaryHistory (INSQL.Runtime.dbo.AnalogSummaryHistory)
- AttributeType
- CalcType
- ChangeNotification
- ChannelStatus
- ChartConfiguration
- ChartConfigurationAuditLog
- ChartConfigurationKeyword
- ChartConfigurationProperty
- ChartConfigurationStatistics
- ChartConfigurationTag
- Comments
- CommentsType
- ConfigStatusPending
- ConfigStatusSnapshot
- Context
- CurrentEditor
- CustomReplicationSchedule
- DashboardConfiguration
- DeletedReplicationTagEntity
- DeletedTag
- DetectorType
- Deviation
- DiscreteSnapshot
- EngineeringUnit
- EngineeringUnitCatalog
- EngineeringUnitDimension
- EngineeringUnitSystem
- ErrorLog
- EventHistory
- EventTagPendingDelete
- Frequency
- GroupTagList
- History (INSQL.Runtime.dbo.History)
- HistoryBlock (INSQL.Runtime.dbo.HistoryBlock)
- HistorianSysObjects
- IntervalReplicationSchedule
- InTouchNode
- InTouchSpecific
- IOServerType
- Limit
- LimitName
- Live (INSQL.Runtime.dbo.Live)
- LocalizedText
- ManualAnalogHistory
- ManualDiscreteHistory
- ManualStringHistory
- Message
- ModLogColumn
- ModLogTable
- NameSpaceIcons
- OPCQualityMap
- PrivateGroupTag
- PrivateNameSpace
- PublicGroupTag
- PublicNameSpace
- QualityMap
- RateOfChange
- ReplicationGroup
- ReplicationRule
- ReplicationSchedule
- ReplicationScheduleType
- ReplicationServer
- ReplicationShard
- ReplicationSyncRequest
- ReplicationSyncRequestPending
- ReplicationTagEntity
- ReplicationType
- SearchMessageSyncRequest
- ServerList
- ShardAssignmentRule
- ShareMode
- SnapshotDetail
- SnapshotTag
- SQLTemplate
- StateSummaryHistory (INSQL.Runtime.dbo.StateSummaryHistory)
- StateWideHistory (INSQL.Runtime.dbo.StateWideHistory)
- StorageLocation
- StorageShard
- StorageType
- StringSnapshot
- StructureAttributes
- StructureType
- SummaryData
- SummaryHistory
- SummaryOperation
- SummaryTagList
- SystemParameter
- TagExtendedPropertyName
- TagGroup
- TagHistory
- TagRef
- TagType
- TimeDetectorDetail
- TimeDetectorDetailPendingDelete
- TimeUnit
- TimeZone
- TopicImportInfo
- UserDetail
- WideHistory (INSQL.Runtime.dbo.WideHistory)
- WideTableDictionary