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
snoopy_SpyAsked:
Who is Participating?
 
kretzschmarConnect With a Mentor Commented:
select distinct rdb$view_name from rdb$view_relations

you must have the select right for the system-table rdb$view_relations
0
 
Phoenix_sCommented:
according to some interbase dox...

the show tables ISQL command shows all tables AND views.

is that helpful?
0
 
Phoenix_sCommented:
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
 
YodaMageCommented:
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
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.

All Courses

From novice to tech pro — start learning today.