|
|
| Author |
Message |
karthikr44
Active User
Joined: 25 Aug 2007
Posts: 105
Location: trichy
|
|
|
|
Cud u pls suggest me an answer on this…
I have a table , say an emp table. I need to track all the views which uses this table as source…
Regards
R.Karthik |
|
| Back to top |
|
 |
References
|
 Posted: Thu Apr 24, 2008 3:20 pm Post subject: Re: To track all the views which uses the same table |
|
|
|
|
ashimer
Active User
Joined: 13 Feb 2004
Posts: 267
Location: Bangalore
|
|
|
|
try this
| Code: |
select name from sysibm.sysviews where text like '%table_name%';
|
|
|
| Back to top |
|
|
Bharath Bhat
New User
Joined: 20 Mar 2008
Posts: 37
Location: chennai
|
|
|
|
Go to Platinum
| Code: |
DB2 Object ===> T Option ===> V Where => N
Table Name ===> emp > Creator ===> *
Qualifier ===> * > Grantor ===> * |
It will list all the views on the table emp. |
|
| Back to top |
|
|
Anuj D.
Senior Member
Joined: 22 Apr 2006
Posts: 1345
Location: Mumbai, India
|
|
|
|
| Do you have BMC Software Administrative Products for DB2 installed at your shop? |
|
| Back to top |
|
|
|
|
