How to check the Azure SQL Database edition

Rene Castro - Dataedo Team Rene Castro 2019-04-01

Table of Contents:


    Article for: Azure SQL Database SQL Server MySQL MariaDB IBM Db2

    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

    0
    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).
    Accept