You can control whether a regular view is available for use by the database server by enabling or disabling it.
You must be a user with DBA authority or be the owner of the view.
Before you enable a regular view, you must re-enable any disabled views that it references.
Context and remarks
If you disable a view, other views that reference it, directly or indirectly, are automatically disabled. So, once you re-enable a view, you must re-enable all other views that were dependent on the view when it was disabled. You can determine the list of dependent views before disabling a view using the sa_dependent_views system procedure.
Connect to the database.
To disable a regular view, execute an ALTER VIEW...DISABLE statement.
To enable a regular view, execute an ALTER VIEW...ENABLE statement.
The following example disables a regular view called ViewSalesOrders owned by GROUPO.
ALTER VIEW GROUPO.ViewSalesOrders DISABLE;
The following example re-enables the regular view called ViewSalesOrders owned by GROUPO.
ALTER VIEW GROUPO.ViewSalesOrders ENABLE;
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|