To browse the data held within the views, you can use Interactive SQL. Interactive SQL lets you execute queries to identify the data you want to view. See Querying data.
If you are working in Sybase Central, you can select a view on which you have permission and then choose File » View Data In Interactive SQL. This command opens Interactive SQL with the view contents displayed on the Results tab in the Results pane. To browse the view, Interactive SQL executes a
SELECT * FROM owner.view statement.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|