Previous | Index | Next |
3 SQL Features
This chapter describes all available SQL features of the AuDAO generator.
- 3.1 SQL Features
- 3.1.1 Primary Keys
- 3.1.2 Indexes
- 3.1.3 Foreign Keys
- 3.1.4 Sequences
- 3.1.5 Data
3.1 SQL Features
3.1.1 Primary Keys
Primary keys are automatically generated on SQL level. Although primary keys can contain more than one column, it is recommended to use only one-column primary keys due to limitations of the DAO layer.
The primary key columns are recognized by the column flag <pk/>.
See also: XSD - column
3.1.2 Indexes
Indexes are automatically generated on SQL level. Both unique and nonunique indexes are supported.
Indexes are defined by separate indexes/index definitions.
See also: XSD - index
3.1.3 Foreign Keys
Foreign keys are automatically generated on SQL level.
Foreign keys are generated when <ref> reference is used.
See also: XSD - ref
3.1.4 Sequences
Sequences are automatically generated on SQL level only for Oracle DB.
Sequences are generated when <auto/> with <pk/> is used.
See also: XSD - column
3.1.5 Data
Data insertion statements are automatically generated for standard databases.
Data insertion statements are generated when <data> definition is present.
See also: XSD - table
Previous | Index | Next |