Kbase P128192: SQL-92: How to modify an SQL-92 VIEW?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/14/2008 |
|
Status: Unverified
GOAL:
SQL-92: How to modify an SQL-92 VIEW definition?
GOAL:
Can an SQL-92 VIEW definition be modified using SQL-92 statements?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
SQL-92 standards provide the CREATE VIEW statement to create a VIEW and the DROP VIEW statement to delete a view. SQL-92 standards do not provide any other DDL statements to modify or change the definition of an existing SQL-92 VIEW object. Hence, the only way to modify or change an SQL-92 VIEW object is by deleting it and recreating it via the DROP VIEW and CREATE VIEW statements.