Solved

Interbase 6.0 Getting all Views

Posted on 2001-08-02
4
169 Views
Last Modified: 2011-10-03
How can i get all View names ?
For getting all Tables i can use GetTableNames but for Views ?
I am using IBX 4.62
0
Comment
Question by:snoopy_Spy
  • 2
4 Comments
 
LVL 1

Expert Comment

by:Phoenix_s
ID: 6346426
according to some interbase dox...

the show tables ISQL command shows all tables AND views.

is that helpful?
0
 
LVL 1

Expert Comment

by:Phoenix_s
ID: 6346434
in addition...

the ISQL command show views will show all views

utilizing the commands as follows gets your results :

show tables - shows all tables & views
show table <tablename>  shows the schema for the specified table/view

show views - shows all views
show view <viewname> shows the schema for the specified view

0
 
LVL 4

Expert Comment

by:YodaMage
ID: 6346435
At first glance, looks like you need to execute SHOW VIEWS in an SQL statement....Though you should also get your views in your GetTableNames return. Usually I use a naming convention like VW_UNIQUENAME to name views, so then GetTableNames with a pattern established as VW_* will return only views.
 
0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 100 total points
ID: 6349717
select distinct rdb$view_name from rdb$view_relations

you must have the select right for the system-table rdb$view_relations
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question