View previous topic :: View next topic
|
Author |
Message |
umed
New User
Joined: 13 May 2005 Posts: 38
|
|
|
|
Hi,
How can we find the tables on which a perticular view has been defined.Here we are having only name of that view with us.
Regards,
Umed |
|
Back to top |
|
|
DavidatK
Active Member
Joined: 22 Nov 2005 Posts: 700 Location: Troy, Michigan USA
|
|
|
|
If you have DB2 FileAid. use option 3.4, then option GD to display the view. |
|
Back to top |
|
|
senthilssg
New User
Joined: 09 Dec 2005 Posts: 64 Location: USA
|
|
|
|
Hi umed,
you can get the table name by getting informattion from the sysibm.sysviews catalog table.
execute the query in the following format in QMF or in SPUFI
SELECT NAME ,TEXT FROM SYSIBM.SYSVIEWS WHERE NAME ='view name '
In output of above query , TEXT column having declaration of that view . from that you can know corresponding table for that given view
Eg:
NAME TEXT
------------------ ---------------------------------------------
EMPLOYEE_VIEW create view employee_view (id ,name, sal) as select emp_id , emp_name,emp_sal from ssgsen.employee;
In that example , table name for the view EMPLOYEE_VIEW is ssgsen .employee; |
|
Back to top |
|
|
|