SQL Query
how to select only those table name from database that have a two field in table like PID amd EID
table that have PID also have a EID in a single table
those table i want to select
Software/Hardware used:
Software
Software/Hardware used:
Software
ASKED:
June 2, 2012 1:14 PM
UPDATED:
June 4, 2012 5:36 PM
Answer Wiki:
<pre>select table_NAME FROM INFORMATION_SCHEMA.COLUMNS
where COLUMN_NAME ='PID'
intersect
select table_NAME FROM INFORMATION_SCHEMA.COLUMNS
where COLUMN_NAME ='EID' </pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
