The following query requests information about particular columns in the employee and department tables (note that each column reference is fully qualified with its table name).
HELP COLUMN employee.name, employee.dept_no, department.dept_no FROM employee, department;
The return from the preceding query lists each column in the order in which it was specified; therefore, the first dept_no column listed is for the employee table, the second is for the department table.
Column Name Type Nullable ----------- ---- -------- Name CV N DeptNo I2 Y DeptNo I2 N