|
|
|
XML format for the sqlView object
The sqlView element is a child of the schema object.
The sqlView contains children elements of type sqlViewColumn and databaseSpecificSql.
<sqlView name="my_new_SQL_view" id=4040 >
<sql>select web_login as owner from table_user union select req_originator as owner from table_fcs_detail</sql>
<sqlViewColumn name="owner" datatype="String" length="40">
<description>this is the owner</description>
</sqlViewColumn>
</sqlView >
Attribute Name |
Required |
Default |
Description |
|---|---|---|---|
name |
Yes |
|
Specifies the name of the sqlView. This must be a unique name amongst all tables and views. |
id |
Yes |
|
Specifies the id number of the sqlView. This must be a unique id amongst all tables and views. The customer range for IDs is 430-511 and 2000-4999. |
sql |
Yes |
|
Specifies the actual SQL for the view. |
description |
No |
|
Description of the sqlView and its purpose. |
groupName |
No |
|
Specifies the name of the application module that the sqlView is used by. |
baseTable |
No |
|
Specifies the name of the main tables used in the view. |
See Also |
Next |