topic Query SQL to show all table names and the SRID in ArcGIS Enterprise Questions

Query SQL to show all table names and the SRID

byander — Tue, 28 Mar 2023 16:41:17 GMT

Hello,

I need to create a query SQL to show all table names and the SRID (EPSG Code) from each table on Enterprise Geodatabase SQL Server.
Currently, I can use this SQL to show the Srid for one table:

SELECT DISTINCT SHAPE.STSrid AS espg_code FROM table_name;

But I need to show Srid for all geometry tables in the database.

I tried some queries but without success.

Re: Query SQL to show all table names and the SRID

CoffeeforClosers — Tue, 28 Mar 2023 16:59:22 GMT

SELECT l.database_name [DatabaseName], l.table_name [TableName], l.owner [SchemaOwner], sr.auth_srid [SRID], srtext [WKT] FROM [database].[dbo].[SDE_layers] l inner join database.dbo.SDE_spatial_references sr on l.srid = sr.srid

Re: Query SQL to show all table names and the SRID

byander — Tue, 28 Mar 2023 19:13:55 GMT

Tank's @CoffeeforClosers , it works!!!!