Is it possible to get all three - i.e. a combination of the two queries..

WHat i would like to get now is the View Name, the View Columns and the...

That is exactly what I wanted. It is perfect.

-Ibrahim Akar

I do not see any difference in the first one you wrote vs. the second one. I am still getting the same result. I get the View name of the...

That is nearly perfect. I say nearly because I want the column names of the view and not the column names of the table. They are different on my tables....

It worked now..thank you.

I am still getting table names with xtype= 'V'