Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » SQL Anywhere Plug-in Help » Introduction to SQL Anywhere property sheets

User property sheet: Permissions tab Next Page

View property sheet: General tab

The General tab of the View property sheet has the following components:

Name    Shows the name of the view.

Type    Shows the type of object.

Owner    Shows the database user who owns the object.

Dbspace    Shows the database file (or dbspace) where the materialized view is located. This only applies to materialized views.

Status    Shows the status of the object. Values include the following:

Recompile and Enable Now    Click to recompile and enable the view, making it available for use by the database.

Before you enable a view, you must re-enable any other views that it references (if they are disabled). See Enabling and disabling views, or Enabling and disabling materialized views.

Disable Now    Click to disable the view. The database server keeps the definition of the view in the database, but makes the view unusable.

Disabling a view can affect queries that explicitly reference it, as well as other views that reference it, directly or indirectly; see Enabling and disabling views, or Enabling and disabling materialized views.

Used in optimization    Select this option to indicate whether the materialized view can be used during query optimization. This applies to materialized views only.

Last refresh time    Shows the date and time that the view was last refreshed. This applies to materialized views only.

Known stale time    Shows the time at which the view became known as stale. This value corresponds to the time at which a change was detected in one of the underlying base tables. This applies to materialized views only.

Comment    Provides a place for you to type a description of the view. For example, you could use this area to describe the view's purpose in the system.

See also