Export (0) Print
Expand All

sys.spatial_reference_systems (Transact-SQL)

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

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft