Kbase P25746: How to remove a view
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/05/2003 |
|
Status: Unverified
GOAL:
How to remove a view
FIX:
The user must have permissions to delete.
Views created for the SQL users and associated to a table where the name is to be changed must be dropped before the table names are changed. To drop a view use the following command:
DROP VIEW <view-name>;
commit