Edit

Version - Transact SQL Metadata functions

  • Article

Applies to: Azure Synapse Analytics Analytics Platform System (PDW)

Returns the version of Azure Synapse Analytics or Analytics Platform System (PDW) running on the appliance.

Transact-SQL syntax conventions

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)