You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

How to get the list of tables having specific field as key.

1 reply [Last post]
peoplekishore's picture
User offline. Last seen 7 years 6 weeks ago. Offline
Joined: 05/13/2008
Posts: 11

HI,

Can anybody help me out with the sql to get the list of tables having specific field as key in the entire database.

ex: In HCM I want to find the list of tables having EMPLID as key field.

Thanks in advance,

Regards
Mastan.

Guest's picture
Guest (not verified)
Re: How to get the list of tables having specific field as key.

Hi Mastan,

query: example----->select * from psrecfldkeysvw where recname='job'
the above query returns total key fields in job table.

try this above query.

Regards
Ravi