>Is there a command that would tell you which tables have a field/column name "XYZ" or which field names contain "XYZ"?
>
You can use INFORMATION_SCHEMA.

SELECT * FROM pubs.INFORMATION_SCHEMA.COLUMNS
	WHERE column_name LIKE '%id%'