[RBASE-L] - Query Against Which SYS_TABLE Searching for COLUMN?

[J. Stephen Wills]

Okay, for all my occasional preaching/sanctimony about Q/A, project control, effectiveness and efficiency, doin' it right, etc, I am only too human and therefore have a bit of management mess on my hands.  I have too many redundant/unversioned/undated copies of databases on my hard drive, but they are not simply copies with incremental additions.  Taken together, they'd have all the data I could possibly want or need, plus all the redundancies ; that is, altogether, they are 100% of my data, including duplicates.  However, I am now trying to coalesce these, which requires that I inspect the values of certain "audit" fields in the various tables, `InsertedOnDT`, `InsertedOnTM`, `ETC`, in order to look for the most recent INSERTS.   Anyway, what I'm specifically looking for, is a good way to get :   A list of distinct table_names that have a column named like this, "Insert%"   I guess along the lines of :   SELECT DISTINCT SYS_TABLE_NAME FROM SYS_whatever WHERE SYS_COLUMN_NAME LIKE "Insert%"     Would anyone be able to correct this/advise me?     Thanks, Steve in Memphis