Hi,
I want to find all the tables name under a database where tables having text like "ID".
Like in a database for example we have Table A, Table B----> Table F' and only table C, table E have text like ID for any of the column value
Table C
Name Product Department
SS ID@s.com CS
AS DD IT
WW ID@s.com EC
Table E
Sales Purchase GName
SS 700 ID@s.com
AS 500 IT
WW 300 ID@s.com
So I want a query which will scan all database tables and return me only the above table name as it contains ID@s.com