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

# Modello dati di SQL Server

Microsoft SQL Server è una piattaforma di database tradizionale. SQL Server supporta ANSI SQL. È disponibile sia come database cloud su Microsoft Azure sia come database tradizionale in esecuzione on-premise o in hosting.

I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.

## Piattaforma

- Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
- Tipo: un'applicazione accessibile tramite la propria API.
- I dati sono suddivisi, ad esempio per azienda o per amministrazione.
- I dati possono essere sia letti che scritti.
- Piani Invantive Cloud: Free per Exact Online, Office per Imprenditori, Office per Commercialisti, Premium Finance, OEM.

## Figure

| Figure | Count |
|---|---:|
| Tables | 54 |
| Columns | 616 |
| Tabella con inserti | 29 |
| Tabella con aggiornamento | 28 |
| Tabella con la clausola DELETE | 28 |
| Tabella documentata | 1 |

## Tabelle

### Database.Invantive

- [Collections](Database.Invantive.Collections): Metadata Collections
- [DataSourceInformation](Database.Invantive.DataSourceInformation): Informazioni sulla sorgente dati
- [DataTypes](Database.Invantive.DataTypes): Tipi di dati
- [PooledConnections](Database.Invantive.PooledConnections): Connessioni in pool
- [Restrizioni](Database.Invantive.Restrictions): Restrizioni

### Database.Metadata

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

### Database.Native

- [NATIVEPLATFORMSCALARREQUESTS](Database.Native.NATIVEPLATFORMSCALARREQUESTS): Richieste scalari della piattaforma nativa

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

## Attributi

Le caratteristiche di questa piattaforma sono riportate nella pagina [Attributes](attributes).
