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. See Statuses for regular views.
If the status is 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.
If the status is 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.
If the status is 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.
Recompile and Enable Now Click this button 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 Disabling or enabling a regular view (Sybase Central).
Disable Now Click this button 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 Disabling or enabling a regular view (Sybase Central).
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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|