Check a Azure SQL database is Managed instance or standalone

Question

Hi All,

How can I check whether a Azure database is part of Azure managed instance or standalone database?

Thanks
SS

Answer 1

Please see T-SQL example:

IF( SERVERPROPERTY('EngineEdition') = 8 )   
BEGIN  
    PRINT 'This is an Azure SQL Managed Instance.';  
END  
ELSE  
BEGIN  
PRINT 'This is NOT an Azure SQL Managed Instance.';  
END  

Value 5 (SQL Database) belongs to Azure SQL. See all possible Engine Editions here.