The queries below return the product and server edition.

Installed product

This query returns the installed product edition of the Azure SQL Database. Use it to determine the features and the limits.

Query

select serverproperty('Edition') as [edition]

Columns

• edition - Azure SQLDatabase edition

Rows

The query returns just one row

Sample results

Edition

Returns the database engine edition.

Query

select case
    when serverproperty('EngineEdition') = 5 then 'SQL Azure'
    when serverproperty('EngineEdition') = 6 then 'Azure SQL Data Warehouse'
    when serverproperty('EngineEdition') = 8 then 'Managed Instance'
    end as [edition]

Columns

• edition - Azure SQL Database edition:
  • Azure SQL Database
  • Azure SQL Datawarehouse
  • Managed Instance

Rows

The query returns just one row

Sample results