Informix Guide to SQL: Tutorial Programming with SQL

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 or the Relational Object Manager. 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 Informix Guide to SQL: Syntax and the Informix Guide to Database Design and Implementation.