SQLSPECIALCOLUMNS

The SQLSPECIALCOLUMNS view contains one row for every column of a primary key, unique constraint, or unique index that can identify a row of the table.

The following table describes the columns in the view:

Table 1. SQLSPECIALCOLUMNS view
Column Name	Data Type	Description
SCOPE	SMALLINT	Reserved. Contains 0.
COLUMN_NAME	VARCHAR(128)	Column name
DATA_TYPE	SMALLINT	The data type of the column: –5 BIGINT 4 INTEGER 5 SMALLINT 3 DECIMAL 2 NUMERIC 8 DOUBLE PRECISION 7 REAL -360 DECFLOAT 1 CHARACTER –2 CHARACTER FOR BIT DATA 12 VARCHAR –3 VARCHAR FOR BIT DATA 40 CLOB –95 GRAPHIC –96 VARGRAPHIC –350 DBCLOB –8 NCHAR –9 NVARCHAR –10 NCLOB –2 BINARY –3 VARBINARY 30 BLOB 91 DATE 92 TIME 93 TIMESTAMP 70 DATALINK –100 ROWID 17 DISTINCT
TYPE_NAME	VARCHAR(260)	The name of the data type of the parameter: BIGINT BIGINT INTeger INTEGER SMALLINT SMALLINT DECIMAL DECIMAL NUMERIC NUMERIC FLOAT DOUBLE PRECISION REAL REAL DECFLOAT DECFLOAT CHARacter CHARACTER CHARacter FOR BIT DATA CHARACTER FOR BIT DATA VARCHAR VARCHAR VARCHAR FOR BIT DATA VARCHAR FOR BIT DATA CLOB CLOB GRAPHIC GRAPHIC VARGRAPHIC VARGRAPHIC DBCLOB DBCLOB NCHAR NCHAR NVARCHAR NVARCHAR NCLOB NCLOB BINARY BINARY VARBINARY VARBINARY BLOB BLOB DATE DATE TIME TIME TIMESTAMP TIMESTAMP DATALINK DATALINK ROWID ROWID XML XML Qualified Type Name DISTINCT
COLUMN_SIZE	INTEGER	The length of the column.
BUFFER_LENGTH	INTEGER	Indicates the length of the column in a buffer.
DECIMAL_DIGITS	SMALLINT Nullable	Indicates the number of digits for a numeric column. Contains the null value if the column is not numeric.
PSEUDO_COLUMN	SMALLINT	Indicates whether this is a ROWID, identity, or row change timestamp column. 1 The column is not a ROWID, identity, or row change timestamp column. 2 The column is a ROWID, identity, or row change timestamp column.
TABLE_CAT	VARCHAR(128)	Relational database name
TABLE_SCHEM	VARCHAR(128)	Name of the SQL schema that contains the table.
TABLE_NAME	VARCHAR(128)	Name of the table.
NULLABLE	SMALLINT	Indicates whether the column can contain the null value. 0 The column is not nullable. 1 The column is nullable.
JDBC_DATA_TYPE	SMALLINT	Indicates the JDBC data type of the column. –5 BIGINT 4 INTEGER 5 SMALLINT 3 DECIMAL 2 NUMERIC 8 DOUBLE PRECISION 7 REAL 1111 DECFLOAT 1 CHARACTER or GRAPHIC -15 NCHAR –2 CHARACTER FOR BIT DATA or BINARY 12 VARCHAR or VARGRAPHIC -9 NVARCHAR –3 VARCHAR FOR BIT DATA or VARBINARY 2005 CLOB or DBCLOB 2011 NCLOB 2004 BLOB 91 DATE 92 TIME 93 TIMESTAMP 70 DATALINK -8 ROWID 2009 XML 2001 DISTINCT
I_DATA_TYPE	SMALLINT	Indicates the IBM® i CLI data type of the column. 19 BIGINT 4 INTEGER 5 SMALLINT 3 DECIMAL 2 NUMERIC 8 DOUBLE PRECISION 7 REAL -360 DECFLOAT 1 CHARACTER –2 CHARACTER FOR BIT DATA or BINARY 12 VARCHAR –3 VARCHAR FOR BIT DATA or VARBINARY 14 CLOB 95 GRAPHIC or NCHAR 96 VARGRAPHIC or NVARCHAR 15 DBCLOB or NCLOB 13 BLOB 91 DATE 92 TIME 93 TIMESTAMP 16 DATALINK 1111 ROWID -370 XML 2001 DISTINCT
SOURCE_TYPE_NAME	VARCHAR(128) Nullable	If the column data type is a user-defined type, the built-in data type name of its source type. Contains the null value if the column data type is not a user-defined type.
SOURCE_SQL_DATA_TYPE	SMALLINT Nullable	If the column data type is a user-defined type, the built-in SQL_DATA_TYPE of its source type. For values see SQL_DATA_TYPE. Contains the null value if the column data type is not a user-defined type.
SOURCE_JDBC_DATA_TYPE	SMALLINT Nullable	If the column data type is a user-defined type, the built-in JDBC_DATA_TYPE of its source type. For values see JDBC_DATA_TYPE. Contains the null value if the column data type is not a user-defined type.