query to check srid of features in feature class? [duplicate]

Question

What query should I use to check the SRID of the features in a feature class? The storage type of the feature class in st_geometry?

I tried the following query but no luck :

select top 1 [geomColumnName].STSrid from [schema].[feature class];

Answer 1

Just after posting this question I did some more research and testing. I found the query:

SELECT sde.st_srid (SHAPE) sridcol FROM schema.featureclassname;

I referred to the following link:

http://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/st-srid.htm

Answer 2

have you tried the following syntax

SELECT [geomColumnName].STSrid as srid, * FROM [schema].[tableName]

I got this from the following question

personally I would just use the following since the srid will be the same for all features in a feature class:

SELECT distinct [geomColumnName].STSrid as srid FROM [schema].[tableName]