|
View previous topic :: View next topic
|
| Author |
Message |
karthikr44
Active User
Joined: 25 Aug 2007
Posts: 235
Location: Chennai
|
|
|
|
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 |
|
 |
ashimer
Active Member
Joined: 13 Feb 2004
Posts: 551
Location: Bangalore
|
|
|
|
try this
| Code: |
select name from sysibm.sysviews where text like '%table_name%';
|
|
|
| Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008
Posts: 283
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 Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| Do you have BMC Software Administrative Products for DB2 installed at your shop? |
|
| Back to top |
|
|
|
|
