I have many tables in my ESRI SDE, within most of these tables they contain an Asset_ID, this colmn name varies, it could be many things including AID, AssetID, ASSETID, Asset_ID etc.
I need to extract all rows from all tables where the Asset_ID field is present, and has been populated, then push the row into a GeoPackage. That part I am OK with, I just have never worked with the first part, iterating over n number of tables, searching for a varying field name.
Can anyone provide any comments or samples to get me off the ground here?
I greatly appreciate you taking the time.
Kind regards,
Ben