View Properties window: General tab

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.

 See also
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0