department表は次のように定義されています。
CREATE TABLE personnel.department ( dept_no SMALLINT NOT NULL, dept_name VARCHAR(12) CHARACTER SET UNICODE, loc CHARACTER(8) CHARACTER SET UNICODE, mgr_no INTEGER NOT NULL) UNIQUE PRIMARY INDEX (dept_no);
以下のリクエストは、department表についての情報を返します。
HELP TABLE personnel.department;
Column Name dept_no
Type I2
Comment Department number
Nullable N
Format -(10)9
Title ?
Max Length 4
Decimal Total Digits ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
Uppercase N
Table/View? T
Default value ?
Character Type ?
IDCol Type ?
UDT Name ?
Temporal N
Column Dictionary Name dept_no
Column SQL Name dept_no
Column Name UEscape
Dictionary Title
SQL Title
Title UEscape
Column Name dept_name
Type CV
Comment Department name
Nullable N
Format X(12)
Title ?
Max Length 8
Decimal Total Digits ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
Uppercase N
Table/View? T
Default Value ?
Character Type 2
IDCol Type ?
UDT Name ?
Temporal N
Column Dictionary Name dept_name
Column SQL Name dept_name
Column Name UEscape
Dictionary Title
SQL Title
Title UEscape
Column Name loc
Type CF
Comment Department location
Nullable N
Format X(18)
Title ?
Max Length 18
Decimal Total Digits ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
Uppercase N
Table/View? T
Default Value ?
Character Type 2
IDCol Type ?
UDT Name ?
Temporal N
Column Dictionary Name loc
Column SQL Name loc
Column Name UEscape
Dictionary Title
SQL Title
Title UEscape
Column Name mgr_no
Type I
Comment Employee number of department manager
Nullable N
Format -(10)9
Title ?
Max Length ?
Decimal Total Digits ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
Uppercase ?
Table/View? T
Indexed? Y
Unique? Y
Default Value ?
Character Type ?
IDCol Type ?
UDT Name ?
Temporal N
Column Dictionary Name mgr_no
Column SQL Name mgr_no
Column Name UEscape
Dictionary Title
SQL Title
Title UEscape