Query below finds all tables that have 'last_name' column.
select table_schema, table_name from v_catalog.columns where column_name = 'last_name' order by table_schema, table_name;
- table_schema - name of schema of found table
- table_name - name of found table
- One row represents a table
- Scope of rows: all found tables
- Ordered by table schema
List of tables that have 'last_name' column.