Solved

Interbase 6.0 Getting all Views

Posted on 2001-08-02
4
168 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delphi selector screen 2 84
Reconfigure Delphi Install? 2 60
How to Get Images From Server using App Tethering 11 39
shape, triangle, dbctrlgrid 3 17
The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…

792 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