Table Names

Sybase IQ 15.4 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, use this table to update the table names or permissions in your scripts or applications.

Demo database table names
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

Note: 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.