ResultSetMetadata interface

Associated with a ResultSet object and contains a method that provides column information.

Syntax

public interface ResultSetMetadata

Members

All members of ResultSetMetadata interface, including all inherited members.

Name	Description
getAliasName method	Returns the alias name for a column.
getColumnCount method	Returns the total number of columns in the ResultSet object.
getCorrelationName method	Returns the correlation name for a column.
getDomainName method	Returns the name of the domain.
getDomainPrecision method	Returns the precision of the domain value.
getDomainScale method	Returns the scale of the domain value.
getDomainSize method	Returns the size of the domain value.
getDomainType method	Returns the type of the domain.
getQualifiedName method	Returns the qualified name for a column.
getTableColumnName method	Returns the column name in the table or the derived table.
getTableName method	Returns the table name for a column.
getWrittenName method	Returns the written name for a column.

Remarks

This interface is obtained with the ResultSet.getResultSetMetadata method.

When a column in the select list of the ResultSet object is a simple name or a compound name (table-name.column-name, correlation-name.column-name), then, the following information about that name can be extracted if it exists:

Alias name
Correlation name
Qualified version of the name
Table name
The name as written

For each column in the select list of the ResultSet object, the following information about the column domain can be obtained:

Column Type: an integer from the Domain interface
Name of the domain
Size of the domain, for VARCHAR and BINARY domains
Scale and precision, for NUMERIC domains