Find Layers With Versioning

User35489

Good Day Gents,

I am looking for a query or a method which can list me all the 'layers with versioning' in a geodatabse.
Please let me know.


Thanks
-AS

WilliamCraft

In Oracle, this should give you the list of VERSIONED object classes for a 9.3.1 geodatabase along with their respective A, D, F, and S tables:

SELECT r.OWNER, r.TABLE_NAME, r.ADDS_TABLE, r.DELETES_TABLE,
CASE
    WHEN l.LAYER_ID IS NOT NULL THEN ('F'||l.LAYER_ID)
    ELSE ' '
END feature_table,
CASE
    WHEN l.LAYER_ID IS NOT NULL THEN ('S'||l.LAYER_ID)
    ELSE ' '
END spatial_table
FROM (
SELECT OWNER, TABLE_NAME, OBJECT_FLAGS,
substr('A'||registration_id,1,10) adds_table,
substr('D'||registration_id,1,10) deletes_table
FROM SDE.TABLE_REGISTRY
WHERE OBJECT_FLAGS IN ('11', '15', '16399', '114693') AND OWNER IN ('[schema you care about]')
ORDER BY OWNER, TABLE_NAME) r
LEFT JOIN SDE.LAYERS l ON l.OWNER = r.owner AND l.TABLE_NAME = r.TABLE_NAME;