Find all VIEWS for a table in DB2.

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Post Reply
Vikash S
New Member
Posts: 1
Joined: Wed Feb 11, 2015 10:56 am

Find all VIEWS for a table in DB2.

Post by Vikash S »

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?
zprogrammer
Global Moderator
Global Moderator
Posts: 588
Joined: Wed Nov 20, 2013 11:53 am
Location: Mars

Re: Find all VIEWS for a table in DB2.

Post by zprogrammer »

1.Check SYSIBM.SYSVIEWS
2.If you have access to ADMIN TOOL/PLATINUM/BMC the information can be retrieved as well
zprogrammer
Post Reply

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

Register

Sign in

Return to “IBM DB2 and IMS DB/DC”