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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for