Query data from unknown set of tables within file Geodatabase

EvanLortie

I will preface this with I am new to ESRI and the associated development kits.

I am trying to get at the data contained within a file Geodatabase with the constraint of not necessarily knowing what the table name(s) are to begin with.  This is proving quite difficult through this api.

The only method (OpenTable) to obtain a reference to a table via the Geodatabase object requires you to pass in a string of said table's name/id.  This creates a circular chicken/egg situation for me...

The second route I attempted was using the ExecuteSQL method, but that proved just as fruitless trying to obtain the table data without actually knowing any of the table names.  I tried several SQL iterations attempting to pull data from the tables either via a name wild card of a table index, none of which resulted in values -- just the invalid SQL error.  I am very SQL inexperienced so that is likely on me.  I was able to query the required data when I passed in the table name to my SQL statement.

"SELECT * FROM <tableName>" works with "tablexyz" not (* or sys.tables, etc)

Is there a way to obtain a reference to a table within a file Geodatabase without actually knowing the table's name?  The file Geodatabase might have multiple tables as well.  I am surprised there is not an enumeration or listing mechanic off the Geodatabase object for all of the contained tables.

Thanks for any insight
-Evan

LanceShipman

See the geodatabase function GetChildDatasets. It will list all tables, feature classes, etc. in a file geodatabase.