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
For getting all Tables i can use GetTableNames but for Views ?
I am using IBX 4.62
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
the show tables ISQL command shows all tables AND views.
is that helpful?