Solved

Interbase 6.0 Getting all Views

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
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 shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now