SQL Server Data Model
Microsoft SQL Server is a traditional database platform. SQL Server supports ANSI SQL. It is available both as a cloud database on Microsoft Azure as a traditional database running on-premise or hosted.
Text comparisons on this platform are case sensitive.
Platform
- Used from: Invantive Cloud and the Invantive products on your own computer or server.
- Kind: an application reached over its API.
- The data is partitioned, such as per company or administration.
- Data can be written as well as read.
- Invantive Cloud plans: Free for Exact Online, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
Figures
| Figure | Count |
|---|---|
| Tables | 54 |
| Columns | 616 |
| Tables with insert | 29 |
| Tables with update | 28 |
| Tables with delete | 28 |
| Tables documented | 1 |
Data Model Poster
This data model declares no keys yet; the dotted relations are derived from column names.
On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.
The poster as text: tables per topic and their relations
Invantive (without relations)
Collections, DataSourceInformation, DataTypes, PooledConnections, Restrictions
Native (without relations)
master dbo (without relations)
spt_fallback_db, spt_fallback_dev, spt_fallback_usg, spt_monitor, spt_values
msdb dbo (without relations)
autoadmin_backup_configuration_summary, backupfile, backupmediafamily, backupmediaset, backupset, dm_hadr_automatic_seeding_history, logmarkhistory, restorefile, restorefilegroup, restorehistory, suspect_pages, sysdac_instances, syspolicy_conditions, syspolicy_configuration, syspolicy_object_sets, syspolicy_policies, syspolicy_policy_categories, syspolicy_policy_category_subscriptions, syspolicy_policy_execution_history, syspolicy_policy_execution_history_details, syspolicy_system_health_state, syspolicy_target_set_levels, syspolicy_target_sets
Tables
Database.Invantive
- Collections: Metadata Collections
- DataSourceInformation: Data Source Information
- DataTypes: Data Types
- PooledConnections: Pooled Connections
- Restrictions: Restrictions
Database.Metadata
- AllColumns
- ColumnSetColumns
- Columns
- DataSourceInformation
- DataTypes
- Databases
- ForeignKeys
- IndexColumns
- Indexes
- MetaDataCollections
- ProcedureParameters
- Procedures
- ReservedWords
- Restrictions
- StructuredTypeMembers
- Tables
- UserDefinedTypes
- Users
- ViewColumns
- Views
Database.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
master.dbo
msdb.dbo
- autoadmin_backup_configuration_summary
- backupfile
- backupmediafamily
- backupmediaset
- backupset
- dm_hadr_automatic_seeding_history
- logmarkhistory
- restorefile
- restorefilegroup
- restorehistory
- suspect_pages
- sysdac_instances
- syspolicy_conditions
- syspolicy_configuration
- syspolicy_object_sets
- syspolicy_policies
- syspolicy_policy_categories
- syspolicy_policy_category_subscriptions
- syspolicy_policy_execution_history
- syspolicy_policy_execution_history_details
- syspolicy_system_health_state
- syspolicy_target_set_levels
- syspolicy_target_sets
Attributes
The attributes of this platform are on the page Attributes.