Creating a Database (Data Definition Guide)

Go Up to Creating Databases (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.

Topics

• Database File Naming Conventions
• Creating a Database Using a Data Definition File
• Using CREATE DATABASE
• Creating Read-only Databases

Advance To:

• Database File Naming Conventions