4

The ".sde" file is simply a ESRI file format that contains the connection information required to connect to an ESRI enterprise geodatabase. Using ArcMap or ArcCatalog, you can right-click on the ".sde" file and choose "Connection Properties" to see all the database connection information. This includes the database host machine, the database name and the ...


2

The documentation (What is a versioned view) covers this in detail: A versioned view incorporates a database view, stored procedures, triggers, and functions to allow you to use Structured Query Language (SQL) to read or edit data in a geodatabase that has been registered to use traditional versioning. When you query a versioned view, you can see the data ...


1

@BERA has a good answer but it can be made more efficient by skipping the creation of lists and by breaking the iteration of the cursor if a value is found. import arcpy arcpy.env.workspace = "C:/myWorkspace.sde" tables = arcpy.ListTables("X_*") for table in tables: vals = False with arcpy.da.SearchCursor(table, ['FieldA','FieldB']) as cursor: ...


1

Use the da.SearchCursor to create a list of all entries then check list: import arcpy arcpy.env.workspace = "C:/myWorkspace.sde" tables = arcpy.ListTables("X_*") for table in tables: all_rows = [] with arcpy.da.SearchCursor(table, ['FieldA','FieldB']) as cursor: for row in cursor: all_rows.extend(row) if all_rows.count(None) ...


1

A simple hex dump of an .sde string using a program like HxD shows that most of the connection properties are available. It would be left up to the programmer to reverse engineer the structure. As long as the connection string does not store a password it should be possible. e.g.


Only top voted, non community-wiki answers of a minimum length are eligible