Creating a View

Create a new regular view by defining a SQL query using the Create View wizard.

Prerequisites
Database Version View Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority
  • RESOURCE authority with SELECT permission on the tables in the view definition to create a view owned by you.
SAP Sybase IQ 16.0 View to be owned by self –
  • Requires CREATE VIEW system privilege.
  • Also requires one of:
    • SELECT ANY TABLE system privilege.
    • SELECT object permission on the underlying tables of the view.
View to be owned by any user – Requires one of:
  • CREATE ANY VIEW system privilege.
  • CREATE ANY OBJECT system privilege.
  • Also requires one of:
    • SELECT object permission on the underlying tables of the view.
    • SELECT ANY TABLE system privilege.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the left pane, select IQ Servers > Schema Objects > Views > Views.
  3. Click the arrow next to View and select New.
    The Create View Wizard appears.
  4. On the Welcome page, specify
    Option Description
    Select a resource for which the view will be created From the list, select the resource for which the view will be created.
    Which user or group do you want to own the view? From the list, select the user or role/group to own the view.
    What do you want to name the view? Enter a unique name for the new view; maximum of 128 characters.
    Comment Specify a comment for the view.
  5. Click Next.
  6. On the SQL page, define a SELECT statement for the view.
  7. Click Next.
  8. On the Options page, select Enable this view to enable the view
  9. Click Finish.
Parent topic: Views
Related concepts
About Views
View Permissions
View Triggers
Related tasks
Viewing View Data in the Execute SQL Window
Recompiling and Enabling a View
Disabling a View
Deleting a View
Generating View DDL Commands
Viewing or Modifying View Properties
Authenticating a Login Account for a Managed Resource
Related reference
View Privilege Summary