Edition Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
The possible values returned by SERVERPROPERTY('EngineEdition'). See https://learn.microsoft.com/sql/t-sql/functions/serverproperty-transact-sql for more details
public enum Editiontype Edition = Public Enum Edition- Inheritance
-
Edition
Fields
| Name | Value | Description |
|---|---|---|
| Unknown | 0 | |
| PersonalOrDesktopEngine | 1 | Personal or Desktop Engine (Not available in SQL Server 2005 (9.x) and later versions.) |
| Standard | 2 | Standard (For Standard, Web, and Business Intelligence.) |
| EnterpriseOrDeveloper | 3 | Enterprise (For Evaluation, Developer, and Enterprise editions.) |
| Express | 4 | Express (For Express, Express with Tools, and Express with Advanced Services) |
| SqlDatabase | 5 | Azure SQL Database |
| AzureSynapseDedicatedSqlPool | 6 | Azure Synapse dedicated SQL pool (formerly DataWarehouse) |
| SqlDataWarehouse | 6 | Azure Synapse dedicated SQL pool (formerly DataWarehouse) |
| SqlStretchDatabase | 7 | Stretch Database |
| SqlManagedInstance | 8 | Azure SQL Managed Instance |
| SqlDatabaseEdge | 9 | Azure SQL Edge (For all editions of Azure SQL Edge) |
| SqlAzureArcManagedInstance | 10 | Azure Arc Managed SQL Instance |
| SqlOnDemand | 11 | Azure Synapse serverless SQL pool (SQL OnDemand) |