sp_iqtable Procedure Examples

sp_iqtable output examples.

Example 1

The following variations in syntax both return information about the table Departments:

sp_iqtable ('Departments')

sp_iqtable table_name='Departments'

Table_name	Table_type	Table_owner
Departments	BASE	GROUPO

Server_type	location	dbspace_id
IQ	Main	16387

isPartitioned	Remarks	table_constraints
N	contains the names and heads of the various departments in the sporting goods company	(NULL)

PartitionType	isRlv
None	F

The following variations in syntax both return all tables that are owned by table owner GROUPO:

sp_iqtable NULL,GROUPO

sp_iqtable table_owner='GROUPO'

Table_name	Table_type	Table_owner	Server_type	location
Contacts	BASE	GROUPO	IQ	Main
Customers	BASE	GROUPO	IQ	Main
Departments	BASE	GROUPO	IQ	Main
Employees	BASE	GROUPO	IQ	Main
FinancialCodes	BASE	GROUPO	IQ	Main
FinancialData	BASE	GROUPO	IQ	Main
Products	BASE	GROUPO	IQ	Main
SalesOrders	BASE	GROUPO	IQ	Main
SalesOrderItems	BASE	GROUPO	IQ	Main

dbspace_id	isPartitioned	Remarks	table_constraints
16387	N	names, addresses, and telephone numbers of all people with whom the company wishes to retain contact information	(NULL)
16387	N	customers of the sporting goods company	(NULL)
16387	N	contains the names and heads of the various departments in the sporting goods company	(NULL)
16387	N	contains information such as names, salary, hire date and birthday	(NULL)
16387	N	types of revenue and expenses that the sporting goods company has	(NULL)
16387	N	revenues and expenses of the sporting goods company	(NULL)
16387	N	products sold by the sporting goods company	(NULL)
16387	N	individual items that make up the sales orders	(NULL)
16387	N	sales orders that customers have submitted to the sporting goods company	(NULL)