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 |
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) |
PartitionType | isRlvd |
---|---|
None | F |
None | F |
None | F |
None | F |
None | F |
None | F |
None | F |
None | F |
None | F |