Link to home
Start Free TrialLog in
Avatar of snoopy_Spy
snoopy_Spy

asked on

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
Avatar of Phoenix_s
Phoenix_s

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.
 
ASKER CERTIFIED SOLUTION
Avatar of kretzschmar
kretzschmar
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial