Hi all,
What is the way to find all the views that are created for a particular DB2 Table? Can you please help me to know how can I identify that?
Find all VIEWS for a table in DB2.
-
- Global Moderator
- Posts: 588
- Joined: Wed Nov 20, 2013 11:53 am
- Location: Mars
Re: Find all VIEWS for a table in DB2.
1.Check SYSIBM.SYSVIEWS
2.If you have access to ADMIN TOOL/PLATINUM/BMC the information can be retrieved as well
2.If you have access to ADMIN TOOL/PLATINUM/BMC the information can be retrieved as well
zprogrammer
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute