How to get view Definition

Dhani Reddy · New User Joined: 18 Jul 2006 Posts: 20

Hi,

I want to update view columns, can anyone please help me to get underlying tables information for view.

query for view definition.

Thanks,
Aravind

Naish · New User Joined: 07 Dec 2006 Posts: 82 Location: UK

Did you search the forum and the like?

Dhani Reddy · New User Joined: 18 Jul 2006 Posts: 20

I have searched the forum, but did not get view definition query..

Thanks,
Aravind

GuyC · Posted: Thu Jun 14, 2012 2:52 pm

sysibm.sysviews, sysibm.sysviewdep

Dhani Reddy · New User Joined: 18 Jul 2006 Posts: 20

Hi,

I need to know, which tables are using for perticuler view.

Thanks

Naish · New User Joined: 07 Dec 2006 Posts: 82 Location: UK

In this span of 20 mins (your first post and GuyC's solution) you could have easily opened the manual (Link at the top) and yourself found out the solution.

No hard feelings but then you are just earning and not learning.

Dhani Reddy · New User Joined: 18 Jul 2006 Posts: 20

Thank you Naish