How do I find my Azure SQL Database Version?

Question

2 Answers select @@version as version; select serverproperty('ProductVersion') as [version],serverproperty('Edition') as [edition]; SELECT name, compatibility_level FROM sys. databases;

What version of SQL does Azure SQL Database use?

Azure SQL Database is based on the latest stable version of the Microsoft SQL Server database engine.

How do I find the SQL database version?

To view database version information:1In SQL Developer, click the Reports tab on the left, near the Connections navigator. ... 2In the Reports navigator, expand Data Dictionary Reports.3Under Data Dictionary Reports, expand About Your Database.4Under About Your Database, click Version Banner.

How do I find my SQL database in Azure?

Connect to the query editor1On your SQL database Overview page in the Azure portal, select Query editor (preview) from the left menu.2On the sign-in screen, provide credentials to connect to the database. You can connect using SQL authentication or Azure AD.

How do I check Microsoft SQL Server version?

Method 1: Connect to the server by using Object Explorer in SQL Server Management Studio. After Object Explorer is connected, it will show the version information in parentheses, together with the user name that is used to connect to the specific instance of SQL Server.

Expert · Answer