sys.spatial_reference_systems (Transact-SQL)

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 has been granted some permission.