Bewerken

Share via


sys.spatial_reference_systems (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

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.

Permissions

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