MySQL May 30, 2020 MySql gets the sql statement for which table a field exists SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.`COLUMNS` WHERE COLUMN_NAME = 'col1' col1 is the subsegment name.