---
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: nl
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/nl/datamodels/sqlserver
original: https://documentation.invantive.eu/en/datamodels/sqlserver
updated: 2026-11-18T23:25:49Z
license: https://documentation.invantive.eu/nl/
---

# SQL Server-datamodel

Microsoft SQL Server is een traditioneel databaseplatform. SQL Server ondersteunt ANSI SQL. Het is beschikbaar zowel als clouddatabase op Microsoft Azure als traditionele database die on-premise of gehost draait.

Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.

## Platform

- Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
- Type: een applicatie die via de API toegankelijk is.
- De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
- Gegevens kunnen zowel worden geschreven als gelezen.
- Invantive Cloud-abonnementen: Free voor Exact Online, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

## Cijfers

| Figure | Count |
|---|---:|
| Tables | 54 |
| Columns | 616 |
| Tabeller med invoegsel | 29 |
| Tabeller med update | 28 |
| Tabellen met de functie 'verwijderen' | 28 |
| Tabeller gedocumenteerd | 1 |

## Tabellen

### Database.Invantive

- [Collections](Database.Invantive.Collections): Metadatacollecties
- [DataSourceInformation](Database.Invantive.DataSourceInformation): Informatie over gegevensbron
- [DataTypes](Database.Invantive.DataTypes): Datatypen
- [PooledConnections](Database.Invantive.PooledConnections): Poolverbindingen
- [Restricties](Database.Invantive.Restrictions): Restricties

### 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)
- [Indexen](Database.Metadata.Indexes)
- [MetaDataCollections](Database.Metadata.MetaDataCollections)
- [ProcedureParameters](Database.Metadata.ProcedureParameters)
- [Procedures](Database.Metadata.Procedures)
- [ReservedWords](Database.Metadata.ReservedWords)
- [Restricties](Database.Metadata.Restrictions)
- [StructuredTypeMembers](Database.Metadata.StructuredTypeMembers)
- [Tabellen](Database.Metadata.Tables)
- [UserDefinedTypes](Database.Metadata.UserDefinedTypes)
- [Gebruikers](Database.Metadata.Users)
- [ViewColumns](Database.Metadata.ViewColumns)
- [Weergaven](Database.Metadata.Views)

### Database.Native

- [NATIVEPLATFORMSCALARREQUESTS](Database.Native.NATIVEPLATFORMSCALARREQUESTS): Scalaire verzoeken op het native platform

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

## Attributen

De kenmerken van dit platform staan op de pagina [Attributes](attributes).
