Views not visible?

[Ruslan Zasukhin]

On 30/7/07 12:13 PM, "Danny Lewkin" <daniel.lewkin at cognosis.be> wrote:

> And while I'm at it, could you guys make an SQL statement SHOW VIEWS also? ;-)
> Let me know if something like that is possible, I'll enter it into mantis if
> so...
> 

Actually VIEW is a Virtual Table.

So I think they should be listed by SHOW TABLES and we need get one more
column, which indicate if table is a view.

It needs look around to see what other dbs have here and choose the best
way.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]