New answers tagged arcsde
You can use arcpy.da walk function. Check the help doc for an example of how to print all FeatureClasses in a workspace. http://resources.arcgis.com/en/help/main/10.2/index.html#//018w00000023000000
SQL-only / database-only possible solutions: A. - add a timestamp column to every layer using systimestamp as default value, then query for latest timestamp B. - add a trigger ON INSERT and ON UPDATE to every layer table, that updates last modified date value for each layer, on a table of your own.
After a bit of a play around, and obtaining a test MXD containing a colleague's database connection, here's the solution: In ArcCatalog, right-click the MXD and select 'Set Data Source(s)'. Select the layers which have a current data source of another user's database connection. If all layers, click Select All. Depending on if you selected some, or all, ...
Also, in the attached ArcCatalog screenshot below are two line feature classes. Their icons are different. Why are different icons signifying? In answer to your second question. The first icon represents a regular SDE feature class. The second icon represents a feature class that hasn't been registered with the geodatabase.
Avoid doing compress in geodatabase, that is not really want you want to accomplish. If you are targeting SDE file all you have to do is invoke sdelayer -o alter -E calc or sdelayer -o alter -E minx,miny,maxx,maxy from python using the subprocess module. you can recalculate the extent of your table by using SQL CTE like this with cte_envelope as ( ...
Top 50 recent answers are included