You can control whether a regular view is available for use by the database server by enabling or disabling it.
You must be the owner, or have one of the following privileges:
To enable a regular view, you must also have the following privileges SELECT privilege on the underlying table(s), or the SELECT ANY TABLE system privilege.
Before you enable a regular view, you must re-enable any disabled views that it references.
Contexte et remarques
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;
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|