|
|
|
The updateSqlView element allows an existing SQL View to be modified.
Example:
<updateSqlView name="wipelm_all" >
<groupName>sqlviewgroupname</groupName>
<description>This is the description of the updated SqlView.</description>
<sql>select web_login as owner from table_empl_user union select req_originator as owner from table_fcs_detail</sql>
</updateSqlView>
Required Attributes:
Attribute Name |
Description |
|---|---|
name |
Specifies the name of the SQL View. |
Optional Child Elements:
Element Name |
Description |
||||
|---|---|---|---|---|---|
description |
Description of the SQL View and its purpose. |
||||
groupName |
Specifies the name of the application module used by the SQL View. |
||||
baseTable |
Specifies the name of the main tables used in the view. |
||||
sql |
The actual SQL that defines the view. Optional Attributes
|
See Also |
Next |