SQL Anywhere and Sybase IQ

SQL Anywhere is a relational database system that can exist with or without IQ.

The catalog store closely resembles a SQL Anywhere store. You may have SQL Anywhere-style tables in your catalog store along with your IQ tables, or you may have a separate SQL Anywhere database.

SQL Anywhere tables have a different format than IQ tables. While the commands you use to create objects in a SQL Anywhere database may be the same as those for an IQ store, there are some differences in the features you can specify in those commands. Always use the command syntax in this book or Reference: Statements and Options for operations in the IQ store.

This guide explains how to manage an IQ store and its associated catalog store. If you have a SQL Anywhere database, or if you have SQL Anywhere-style tables in your catalog store, see the SQL Anywhere documentation for details of how to create, maintain, and use them.