SQL How to find out what tables have a certain column

Is it possible to const开发者_StackOverflowruct a query so that I can find out what tables have a particular column? Then if it has the column query that table for an ID number? Is this possible?

Sure, I think you can look at the contents of the X$Field system table, described here: http://ww1.pervasive.com/library/docs/psql/794/sqlref/sqlsystb.html