Sybase IQ 15 demo database table names are different than those in the 12.x version of the software.
This table includes current and former iqdemo table names. If you are upgrading from an earlier version of Sybase IQ, use this table to update the table names or permissions in your scripts or applications.
12.7 name |
15.x name |
15.x owner |
---|---|---|
contact |
Contacts |
GROUPO |
customer |
Customers |
GROUPO |
department |
Departments |
GROUPO |
employee |
Employees |
GROUPO |
fin_code |
FinancialCodes |
GROUPO |
fin_data |
FinancialData |
GROUPO |
product |
Products |
GROUPO |
sales_order_items |
SalesOrderItems |
GROUPO |
sales_order |
SalesOrders |
GROUPO |
emp1 |
emp1 |
DBA |
iq_dummy |
iq_dummy |
DBA |
sale |
sale |
DBA |
SYSOPTIONDEFAULTS |
DBO |
To create the older asiqdemo version of the demo database, open a command window, change to $IQDIR15/demo, and run this command: mkiqdemo.sh -old. For additional options, use the mkiqdemo.sh -help command.