Creating SQL tables

The easiest way to create the tables on the SQL data source for your application is to allow Dexterity to create them the first time they are accessed. This method ensures that the tables have the correct structure, and have the proper indexes and stored procedures.

You may choose to create SQL tables using some method external to Dexterity. If you do this, keep in mind that the tables must include the DEX_ROW_ID column, as described in Locking. The tables must also have the necessary indexes and auto-generated stored procedures for the tables to be accessed properly. You can use the Table_CreateIndexes() and Table_CreateProcedures() functions in Dexterity to create the indexes and auto-generated stored procedures for such tables.

Documentation Feedback