Create SAP Sybase IQ Databases

To define your database, use SQL statements or a database design tool.

Some application design systems, such as Sybase PowerDesigner®, contain facilities for creating database objects. These tools construct SQL statements that are submitted to the server, typically through its ODBC interface. If you are using one of these tools, you do not need to construct SQL statements to create tables, assign permissions, and so on.

Database design tools such as Sybase PowerDesigner provide a thorough and reliable approach to developing well-designed databases.

• 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.
• IQ Main Store and IQ Temporary Store Space Management
  Options MAIN_RESERVED_DBSPACE_MB and TEMP_RESERVED_DBSPACE_MB provide room for checkpoint, commit, and release savepoint operations.