<html><body><div style="color:#000; background-color:#fff; font-family:lucida console, sans-serif;font-size:10pt"><div id="yiv1994619060"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: 'lucida console', sans-serif; font-size: 10pt;"><div id="yiv1994619060yui_3_7_2_31_1368763198479_39">hello all,</div><div id="yiv1994619060yui_3_7_2_31_1368763198479_39"><br></div><div id="yiv1994619060yui_3_7_2_31_1368763198479_39">i'm trying to get a list of all table names in a db that have a specific column name.</div><div id="yiv1994619060yui_3_7_2_31_1368763198479_39">ie all user tables with a column named 'productID'.</div><div id="yiv1994619060yui_3_7_2_31_1368763198479_39"><br></div><div id="yiv1994619060yui_3_7_2_31_1368763198479_39">do i have to use a combination of SHOW TABLES, SHOW COLUMNS, and a loop <span style="font-size: 10pt;">or is there simpler way?</span></div><div
id="yiv1994619060yui_3_7_2_31_1368763198479_39"><span style="font-size: 10pt;"><br></span></div><div id="yiv1994619060yui_3_7_2_31_1368763198479_39"><span style="font-size: 10pt;">thanks,</span></div><div id="yiv1994619060yui_3_7_2_31_1368763198479_39"><span style="font-size: 10pt;">george</span></div><div id="yiv1994619060yui_3_7_2_31_1368763198479_39"><span style="font-size: 10pt;"><br></span></div><div id="yiv1994619060yui_3_7_2_31_1368763198479_39"><br id="yiv1994619060yui_3_7_2_31_1368763198479_69"></div><div id="yiv1994619060yui_3_7_2_31_1368763198479_39" style="color: rgb(0, 0, 0); font-size: 13.600000381469727px; font-family: 'lucida console', sans-serif; background-color: transparent; font-style: normal;"><br></div><div id="yiv1994619060yui_3_7_2_31_1368763198479_39"><br></div></div></div></div></div></body></html>