Version - Transact SQL Metadata functions

**APPLIES TO:** ![no](media/no.png)SQL Server ![no](media/no.png)Azure SQL Database ![yes](media/yes.png)Azure SQL Data Warehouse ![yes](media/yes.png)Parallel Data Warehouse

Returns the version of SQL Data Warehouse or SQL Data Warehouse Parallel Data Warehouse running on the appliance.

Topic link icon Transact-SQL Syntax Conventions (Transact-SQL)

Syntax

-- Azure SQL Data Warehouse and Parallel Data Warehouse  
VERSION ( )

Arguments

General Remarks

A table name must be specified in a FROM clause for this function to return results. A result row will be returned for each row in the result set for the query; use TOP (Transact-SQL) to limit the number of returned rows.

Examples

The following example returns the version number.

SELECT VERSION();

See Also

SESSION_ID (Transact-SQL)
DB_NAME (Transact-SQL)