Chapter 3 DBMS Reference Guide
The DBMS contains live database reverse engineering queries for retrieving objects (like Table, Columns, and so on) from the database.
Most queries follow the same naming pattern "Sql...Query".
| Item | Description |
|---|---|
| SqlListQuery | Lists objects for selection in the Selection box. SqlListQuery
retrieves objects and fills the reverse engineering window. Then, each of the other queries below are executed for each selected object.
If SqlListQuery
is not defined, standard functions are
used to retrieve objects. SqlAttrQuery,
SqlOptsQuery
etc. will then be executed, if defined.
SqlListQuery
must retrieve the smallest number of columns possible as the process is memory intensive
|
| SqlAttrQuery | Reverse engineers object attributes. SqlAttrQuery
may be unnecessary if SqlListQuery
can retrieve all necessary information. For example, in Sybase Adaptive Server Anywhere 6, a tablespace list query is sufficient to retrieve all information required for use in a PDM
|
| SqlOptsQuery | Reverse engineers physical options |
| SqlListChildrenQuery | Reverse engineers lists child objects, such as columns of a specific index or key, joins of a specific reference |
| SqlSysIndexQuery | Reverse engineers system indexes created by the database |
| SqlChckQuery | Reverse engineers object check constraints |
| SqlPermQuery | Reverse engineers object permissions |
You can define additional queries to recover more attributes during live database reverse engineering. This is to avoid loading SqlListQuery with queries for retrieving attributes not supported by SqlAttrQuery, or objects not selected for reverse engineering. These additional queries must be listed in the ReversedQueries item. For example, SqlColnListQuery is used to exclusively retrieve view columns. This query has to be declared in the ReversedQueries item in order to be taken into account during reverse engineering.
Note: extended queries should not be defined in the ReversedQueries item. For more information on ReversedQueries, see section "Extension mechanism for live database reverse engineering queries".
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |