Select Views

[wayneswc]

Hi

I want to create a list of my views for a colleague and type a few notes explaining what each one does.

I have around a 100 views and rather than type them all out i was wondering if there is a select statement i can use to pull them out or another way of copying the list of view names

Thanks

 

[hmckillop]

this might help some

select * from information_schema.views

"I'm living so far beyond my income that we may almost be said to be living apart

 

[wayneswc]

It helped perfectly...thanks a lot

I can go make a coffee now instead of spending an hour typing!!!