sys.spatial_reference_systems (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2008) yesAzure SQL Database noAzure 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.