sys.spatial_reference_systems (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Lists the spatial reference systems (SRIDs) supported by SQL Server.

Column name Data type Description
spatial_reference_id int The SRID supported by SQL Server.
authority_name nvarchar(128) The authority of the SRID.
authorized_spatial_reference_id int The SRID given by the authority named in authority_name.
well_known_text nvarchar(4000) The WKT representation of the SRID.
unit_of_measure nvarchar(128) The name of the unit of measure.
unit_conversion_factor float The length of the unit of measure in meters.


The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission.