Creating a regular view (Sybase Central)

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.

Prerequisites

DBA authority.

Context and remarks

Many.

 Create a regular view using Sybase Central

  1. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. In the left pane, right-click Views and click New » View.

  3. Follow the instructions in the Create View Wizard.

  4. In the right pane, click the SQL tab to edit the view definition. To save your changes, click File » Save.

Results

The definition for the view you created is added to the database. Each time a query references the view, the definition is used to populate the view with data and return results.

Next

Query the view to examine the results and ensure the correct data is returned.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1