topic Script to Discover Versioned Tables? in Python Questions

Script to Discover Versioned Tables?

Anonymous User — Wed, 15 Aug 2012 19:25:03 GMT

Hello! I'd like a list of tables in my SDE which are versioned, and a list of tables which are not versioned. I know I can see whether or not a table is versioned this way: Feature Class Properties > General Tab > Versioning information, but how can I write a script that would discover that for me?

I don't see these properties available via the Describe function--any thoughts on how to proceed?
Thanks!

Re: Script to Discover Versioned Tables?

RussellBrennan — Thu, 16 Aug 2012 14:44:49 GMT

This should do the trick:

import arcpy  arcpy.env.workspace = r'Database Connections\Test.sde'  dataList = arcpy.ListTables() + arcpy.ListFeatureClasses() + arcpy.ListRasters() + arcpy.ListDatasets("", "Feature")  for dataset in dataList:   desc = arcpy.Describe(dataset)   if desc.isVersioned:     print desc.name

Re: Script to Discover Versioned Tables?

Anonymous User — Thu, 16 Aug 2012 15:58:16 GMT

Thanks so much! I didn't dig far enough--Dataset was the one property group I didn't check. Thanks again!