Show TOC

Table NamesLocate this document in the navigation structure

Demo database table names and owners.

GROUPO Tables

GROUPO tables in iqdemo contain internal information about a fictional company that sells athletic clothing.

Table 1: GROUPO Table Names
Table Name Owner
Contacts GROUPO
Customers GROUPO
Departments GROUPO
Employees GROUPO
FinancialCodes GROUPO
FinancialData GROUPO
Products GROUPO
SalesOrderItems GROUPO
SalesOrders GROUPO
DBA Table Names

The DBA user is the default SAP IQ user and owns these tables.

Table 2: DBA Table Names

Table

Description

iq_dummy

iq_dummy is a one-row, one-column utility table that you can use to extract information from the database. For example, running the NOW() function against iq_dummy returns the current date and time: 

SELECT NOW() FROM iq_dummy
Use of the DUMMY system table in SAP IQ is implied for all queries that do not have a FROM clause. For more information, see DUMMY system table in Reference.

emp1

Sample employee table that includes dept_id, start_date, name, and salary columns.

sale

Sample sales table that includes prod_id, month_num, rep_id, and sales columns.
SYSOPTION - DEFAULTS Table
SYSOPTIONDEFAULTS is a utility table owned by DBO that contains all option names and values. Query this table to see all default option values:
SELECT * FROM SYSOPTIONDEFAULTS
Related Information