sp_iqcolumn Procedure Example

Use the example as a reference for sp_iqcolumn usage.

The following variations in syntax both return all of the columns in the table Departments:

sp_iqcolumn Departments

call sp_iqcolumn (table_name='Departments')

table_name   table_owner  column_name     domain_name  width  scale  nulls  default
Departments  GROUPO       DepartmentID    integer       4        0   N      (NULL)
Departments  GROUPO       DepartmentName  char         40        0   N      (NULL)
Departments  GROUPO       DepartmentHead  integer       4        0   Y      (NULL)

cardinality  est_cardinality  location  isPartitioned  remarks  check
5             5               Main       N             (NULL)   (NULL)
0             5               Main       N             (NULL)   (NULL)
5             5               Main       N             (NULL)   (NULL)

Example 1

The following variation in syntax returns all of the columns in all of the tables owned by table owner DBA.

sp_iqcolumn table_owner='DBA'