Create a view that combines data from one or more sources. Views can improve performance and allow you to control the data that users can query.
You must have the CREATE VIEW system privilege to create views owned by you. You must have the CREATE ANY VIEW or CREATE ANY OBJECT system privilege to create views owned by others.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, right-click Views and click New » View.
Follow the instructions in the Create View Wizard.
In the right pane, click the SQL tab to edit the view definition. To save your changes, click File » Save.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|