---
title: "SQL Server Data Model"
description: "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."
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/sqlserver
original: https://documentation.invantive.eu/en/datamodels/sqlserver
updated: 2026-11-18T23:25:49Z
license: https://documentation.invantive.eu/en/
---

# 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 |

## Tables

### Database.Invantive

- [Collections](Database.Invantive.Collections): Metadata Collections
- [DataSourceInformation](Database.Invantive.DataSourceInformation): Data Source Information
- [DataTypes](Database.Invantive.DataTypes): Data Types
- [PooledConnections](Database.Invantive.PooledConnections): Pooled Connections
- [Restrictions](Database.Invantive.Restrictions): Restrictions

### Database.Metadata

- [AllColumns](Database.Metadata.AllColumns)
- [ColumnSetColumns](Database.Metadata.ColumnSetColumns)
- [Columns](Database.Metadata.Columns)
- [DataSourceInformation](Database.Metadata.DataSourceInformation)
- [DataTypes](Database.Metadata.DataTypes)
- [Databases](Database.Metadata.Databases)
- [ForeignKeys](Database.Metadata.ForeignKeys)
- [IndexColumns](Database.Metadata.IndexColumns)
- [Indexes](Database.Metadata.Indexes)
- [MetaDataCollections](Database.Metadata.MetaDataCollections)
- [ProcedureParameters](Database.Metadata.ProcedureParameters)
- [Procedures](Database.Metadata.Procedures)
- [ReservedWords](Database.Metadata.ReservedWords)
- [Restrictions](Database.Metadata.Restrictions)
- [StructuredTypeMembers](Database.Metadata.StructuredTypeMembers)
- [Tables](Database.Metadata.Tables)
- [UserDefinedTypes](Database.Metadata.UserDefinedTypes)
- [Users](Database.Metadata.Users)
- [ViewColumns](Database.Metadata.ViewColumns)
- [Views](Database.Metadata.Views)

### Database.Native

- [NATIVEPLATFORMSCALARREQUESTS](Database.Native.NATIVEPLATFORMSCALARREQUESTS): Native Platform Scalar Requests

### master.dbo

- [spt_fallback_db](master.dbo.spt_fallback_db)
- [spt_fallback_dev](master.dbo.spt_fallback_dev)
- [spt_fallback_usg](master.dbo.spt_fallback_usg)
- [spt_monitor](master.dbo.spt_monitor)
- [spt_values](master.dbo.spt_values)

### msdb.dbo

- [autoadmin_backup_configuration_summary](msdb.dbo.autoadmin_backup_configuration_summary)
- [backupfile](msdb.dbo.backupfile)
- [backupmediafamily](msdb.dbo.backupmediafamily)
- [backupmediaset](msdb.dbo.backupmediaset)
- [backupset](msdb.dbo.backupset)
- [dm_hadr_automatic_seeding_history](msdb.dbo.dm_hadr_automatic_seeding_history)
- [logmarkhistory](msdb.dbo.logmarkhistory)
- [restorefile](msdb.dbo.restorefile)
- [restorefilegroup](msdb.dbo.restorefilegroup)
- [restorehistory](msdb.dbo.restorehistory)
- [suspect_pages](msdb.dbo.suspect_pages)
- [sysdac_instances](msdb.dbo.sysdac_instances)
- [syspolicy_conditions](msdb.dbo.syspolicy_conditions)
- [syspolicy_configuration](msdb.dbo.syspolicy_configuration)
- [syspolicy_object_sets](msdb.dbo.syspolicy_object_sets)
- [syspolicy_policies](msdb.dbo.syspolicy_policies)
- [syspolicy_policy_categories](msdb.dbo.syspolicy_policy_categories)
- [syspolicy_policy_category_subscriptions](msdb.dbo.syspolicy_policy_category_subscriptions)
- [syspolicy_policy_execution_history](msdb.dbo.syspolicy_policy_execution_history)
- [syspolicy_policy_execution_history_details](msdb.dbo.syspolicy_policy_execution_history_details)
- [syspolicy_system_health_state](msdb.dbo.syspolicy_system_health_state)
- [syspolicy_target_set_levels](msdb.dbo.syspolicy_target_set_levels)
- [syspolicy_target_sets](msdb.dbo.syspolicy_target_sets)

## Attributes

The attributes of this platform are on the page [Attributes](attributes).

