Skip to Content

How to create Sybase Anywhere tables in sybase IQ?

Apr 05, 2017 at 06:43 AM


avatar image
Former Member

Hello Sir/Ma'am,

I am using Sybase IQ server for engineering Project purpose. I am now learning and understanding the concepts of Sybase IQ.

I have question regarding CREATE ENCRYPTED TABLE.
See this link
where it is mentioned that
**"The CREATE TABLE ENCRYPTED clause is supported for SQL Anywhere tables in a Sybase IQ database.**"
Does this really work? If yes then how to create **SQL Anywhere tables in Sybase IQ database**?
As far as I know anything you create should belong to particular database how can be tables created cross databases of different server?

I hope you would provide answer as soon as possible.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Rob Verschoor
Apr 06, 2017 at 09:40 AM

To create a SQL Anywhere table in IQ, add "IN SYSTEM", e.g. CREATE TABLE mytab (a int) IN SYSTEM. This creates the table in the SQL Anywhere area of IQ which serves as a catalog for IQ. You can use many SQL Anywhere features for these tables that cannot be used with IO tables (like spatial datatypes and triggers, just to mention two). Clearly, as SQL Anywhere is a row-oriented DBMS, you won't get any of the IQ-specific features nor the IQ performance benefits from the column-oriented architecture.

Lastly, SQL Anywhere "IN SYSTEM" tables are sometimes also called "Catalog tables"..

10 |10000 characters needed characters left characters exceeded