Data-definition statements, the SQL statements that create databases and modify the definitions of tables, are not usually put into programs. The reason is that they are rarely performed. A database is created once, but it is queried and updated many times.
The creation of a database and its tables is generally done interactively, using DB–Access. These tools can also be run from a file of statements, so that the creation of a database can be done with one operating-system command. The data-definition statements are documented in the IBM Informix: Guide to SQL Syntax and the IBM Informix: Database Design and Implementation Guide.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]