The CREATE TABLE statement creates a new table on the remote server, and defines the proxy table for that table when you use the AT option. You enter the CREATE TABLE statement using Sybase IQ data types. Sybase IQ automatically converts the data into the remote server's native types.
The CHAR data type is incompatible
between Adaptive Server Anywhere and Sybase IQ when the database
is built with BLANK PADDING OFF. If you want
to perform cross-database joins between ASA and IQ tables using character
data as the join key, use the CHAR data type
with BLANK PADDING ON.
If you use the CREATE TABLE statement to create both a local and remote table, and then subsequently use the DROP TABLE statement to drop the proxy table, then the remote table also gets dropped. You can, however, use the DROP TABLE statement to drop a proxy table created using the CREATE EXISTING TABLE statement if you do not want to drop the remote table.
The following statement creates a table named employee on the remote server asiqdemo1, and creates a proxy table named members that maps to the remote location:
CREATE TABLE members ( membership_id INTEGER NOT NULL, member_name CHAR(30) NOT NULL, office_held CHAR( 20 ) NULL) AT 'asiqdemo1..DBA.employee'
For more information, see CREATE TABLE statement in Sybase IQ Reference Manual.
