Creating a Database (Data Definition Guide)
Create a database in
isql with an interactive command or with the
CREATE DATABASE statement in an
isql script file. For a description of creating a database interactively with IBConsole, see the Operations Guide.
Although you can create, alter, and drop a database interactively, it is preferable to use a data definition file because it provides a record of the structure of the database. It is easier to modify a source file than it is to start over by retyping interactive SQL statements.
- Database File Naming Conventions
- Creating a Database Using a Data Definition File
- Using CREATE DATABASE
- Creating Read-only Databases