Example MkTblsEx:

The class COSessionEx wraps three interfaces, ITableDefinition, IIndexDefinition and ITableDefinitionWithConstraints, which provide the same functionality of various DDL (Data Definition Language) statements. This example is designed to answers your following questions.

1. How to add/drop indexes.
2. How to add/drop keys (primary and foreign).
3. How to set up check constraints.
4. How to add/drop fields.
5. How to add/drop tables.

        For how to use DDL statements to complete the above tasks, see example MkTbls.

        The advantage of this method over use of DDL statements is more generic and portable, and your data sources are not required to support common DDL standards. DDL statements are dependent on each of DBMSs.

Goto the list of examples