Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Interbase 6.0 Getting all Views

Posted on 2001-08-02
4
Medium Priority
?
174 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 400 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

877 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