8.6.64 getPseudoColumns(String catalog,String schemaPattern,String tableNamePattern,String columnNamePattern)

(1) Function

This method acquires a description of the pseudo or hidden columns in a particular table within the specified catalog and schema. This method ignores all arguments and always returns an empty result set.

To Page Top

(2) Format

public synchronized ResultSet getPseudoColumns(String catalog,String schemaPattern,String tableNamePattern,String columnNamePattern) throws SQLException

To Page Top

(3) Arguments

String catalog:

Specifies the catalog name. However, any value you specify is ignored.

String schemaPattern:

Specifies a schema name pattern. However, any value you specify is ignored.

String tableNamePattern:

Specifies a table name pattern. However, any value you specify is ignored.

String columnNamePattern:

Specifies a column name pattern. However, any value you specify is ignored.

To Page Top

(4) Return value

This method always returns a ResultSet object that contains no retrieval result rows. The following table lists the format of the returned ResultSet object.

Table 8‒58: Format of returned ResultSet object (getPseudoColumns method)

Column No.	Data type	Column name	Description
1	String	TABLE_CAT	Catalog name
2	String	TABLE_SCHEM	Schema name
3	String	TABLE_NAME	Table name
4	String	COLUMN_NAME	Column name
5	int	DATA_TYPE	SQL type from java.sql.Types
6	int	COLUMN_SIZE	Column size
7	int	DECIMAL_DIGITS	Number of decimal places
8	int	NUM_PREC_RADIX	Radix value
9	String	COLUMN_USAGE	Usage permitted for the column
10	String	REMARKS	Comment column
11	int	CHAR_OCTET_LENGTH	Maximum length (in bytes) of char type column
12	String	IS_NULLABLE	Whether a null value can be used

To Page Top

(5) Exceptions

If the Connection object is closed before this method is executed, the JDBC driver throws an SQLException.

To Page Top