The catalog store closely resembles a SQL Anywhere store. SQL Anywhere is a relational database system that can exist with or without IQ. 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 book explains how you manage your 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.
For a summary of differences between Sybase IQ and SQL Anywhere, see Appendix A, “Compatibility with Other Sybase Databases,” in Reference: Building Blocks, Tables, and Procedures.
