sys.spatial_reference_systems (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric

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.