The SE_SRID_Authority() function
The SE_SRID_Authority() function takes a spatial reference ID and returns the Authority Name and Authority SRID as an LVARCHAR string in the form AuthName:SRID. If the AuthName is null in the sde.spatial_references table for a given spatial reference ID, the srtext is returned.
Syntax
SE_SRID_Authority(SRID integer)
Return type
LVARCHAR
Example
select SE_SRID_Authority(srid) from sde.spatial_references;
(expression) UNKNOWN:0
(expression) EPSG:4135
(expression) EPSG:4267
(expression) EPSG:4269
(expression) EPSG:4326
(expression) UNKNOWN:0
(expression) UNKNOWN:0
(expression) UNKNOWN:0
(expression) AUTH_NAME:1234
(expression) GEOGCS["GCS_Old_Hawaiian",
DATUM["D_OldHawaiian",
SPHEROID["Clarke_1866",6378206.4,294.9786982]],
PRIMEM["Greenwich",0],UNIT["Degree",0.01745329 25199433]]
10 row(s) retrieved.