This tab 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.
Status Shows the status of the object. The following values are supported:
Valid The view is valid and is guaranteed to be consistent with its definition. The database server can make use of this view without any additional work. See Regular view statuses.
Invalid The view is invalid. A view can become invalid after a schema change to a referenced object where the change results in an unsuccessful attempt to enable the view. Views can also become invalid if a table or view that they reference is dropped.
Each time an invalid view is referenced, for example by a query, the database server tries to recompile the view. If the compilation succeeds, the query proceeds. The view's status remains invalid until it is explicitly enabled. If the compilation fails, an error is returned. See Regular view statuses.
Disabled The view has been explicitly disabled by the user. Disabled views are not available for use by the database server for answering queries. Any query that attempts to use a disabled view returns an error. See Regular view statuses.
Recompile and Enable Now Click to recompile and enable the view, making it available for use by the database server.
Before you enable a view, you must re-enable any other views that it references (if they are disabled). See Enable and disable regular 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, and other views that reference it, directly or indirectly. See Enable and disable regular views.
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. Later, if you use the Database Documentation Wizard to document your SQL Anywhere database, you can include these comments in the output. See Documenting a database.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|