Manage SAP Sybase IQ Database Objects

SAP Sybase IQ lets you create, alter, and delete database objects such as tables and views.

Note: SAP Sybase IQ consists of a catalog store and an IQ store. This section explains how you create objects in your IQ store. Tables created in the catalog store have the characteristics of SQL Anywhere tables. To create tables in the catalog store, see the SQL Anywhere documentation.

SAP Sybase IQ Database Design
The right database design enhances data usability and the speed of data retrieval.
View Management
Views are computed tables.
Table Management
When you create a database, the only tables in it are the system tables, which hold the database schema.
Table Partitions
Table partitioning can improve performance by dividing large tables into smaller, more manageable storage objects. Partitions share the same logical attributes of the parent table, but can be placed in separate dbspaces and managed individually.