Database Creation with SQL

You can use SQL statements for defining database objects directly if you build your database from an interactive SQL tool, such as dbisql.

Even if you use an application design tool, you may want to use SQL statements to add features to the database if they are not supported by the design tool.

Once the database is created, you can connect to it and build the tables and other objects that you need in the database.

• Before You Create a Database
  Perform prerequisite actions before creating a database using SQL statements.
• Starting the Utility Database
  You must start the utility database before creating new databases if no databases are built yet.
• Dbspaces Created Automatically
  When you create a database, the database server creates the following four dbspaces:
• Database File Placement
  When you create a database, consider whether you will ever need to move the database. The location of files for dbspaces may also affect performance.
• CREATE DATABASE Statement Defaults
  The CREATE DATABASE statement has two required parameters and several optional parameters.
• Relative Path Names
  You can create a database using a relative or fully qualified path name for each of the files for the database.
• IQ PATH Parameter Guidelines
  The required IQ PATH parameter tells Sybase IQ that you are creating an IQ database, not a SQL Anywhere database.
• IQ PAGE SIZE Parameter Guidelines
  The IQ PAGE SIZE parameter determines memory and disk use.
• Database Size Guidelines
  When you create a database, you set the size and reserve size in MB of the initial IQ database file (the IQ_SYSTEM_MAIN dbspace).
• PAGE SIZE Parameter Guidelines
  You can select a page size for the catalog store with the CREATE DATABASE PAGE SIZE option. The default and minimum value for this option is 4096 (4KB).
• Block Size Guidelines
  In nearly all cases you should rely on the default block size, which is based on the IQ page size.