• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 176
  • Last Modified:

Interbase 6.0 Getting all Views

How can i get all View names ?
For getting all Tables i can use GetTableNames but for Views ?
I am using IBX 4.62
  • 2
1 Solution
according to some interbase dox...

the show tables ISQL command shows all tables AND views.

is that helpful?
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

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.
select distinct rdb$view_name from rdb$view_relations

you must have the select right for the system-table rdb$view_relations
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now