Version - Transact SQL Metadata functions

Applies to: yesAzure Synapse Analytics yesParallel Data Warehouse

Returns the version of Azure Synapse Analytics or Parallel Data Warehouse running on the appliance.

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

Syntax

-- Azure Synapse Analytics 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)