sp_iqtable output examples.
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 |
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) |
PartitionType |
isRlvd |
---|---|
None |
F |
None |
F |
None |
F |
None |
F |
None |
F |
None |
F |
None |
F |
None |
F |
None |
F |