Create Table Facility

Uniface provides a command line facility for generating SQL script files to create database tables, and where applicable, indexes and stored procedures. These scripts can be used by database administrators to prepare the database for a Uniface application or a Uniface Repository.

If the user has DBA authority, or if the DBMS does not need this authority, Uniface can create tables, indexes and relationship definitions 'on the fly'. That is, Uniface creates a new table whenever an attempt is made to write data to a nonexistent table. Creating tables on the fly does not guarantee that all definitions are created, and usually only the user who generated the tables has access. This is useful during development and testing, but not for a production environment.

In a production environment, and for systems that do not allow tables to be created on the fly, it is recommended that you create tables in a more controlled manner to ensure the application database is correctly created and configured. SQL script files generated by Uniface allow this work to be automated.

The Uniface IDE command line switch /genSql createTable enables you to generate files containing SQL commands to create tables for one or more entities. To do so, it uses the DBMS connector settings for the target database, and the modeled entity definitions in the Uniface Repository.

For more information, see /genSql.

Related Topics