Hello MSzI,

Firstly very thanx for your reply and According to your suggestions :-

I created clustered index on ROWID column that is a primary key and i include DOC_CAT, DOC_NO, I_CODE,...

Hi Lowell,

Your query showing tables of any view, but if view contains another view then it is not showing name of that view.

Can u help me in this regard.

Thanx

Neel

Thank you very much Lowell.

This is the right query i was looking for.

Thanx Again.

Thanx Phil

But i need a query to find out tables which are used by view.