getColumns Method (SQLServerDatabaseMetaData)
Retrieves a description of the table columns that are available in the specified catalog.
public java.sql.ResultSet getColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String col)
Parameter
catalog
A String that contains the catalog name.
schema
A String that contains the schema name pattern.
table
A String that contains the table name pattern.
col
A String that contains the column name pattern.
Rückgabewert
A SQLServerResultSet object.
Ausnahmen
Hinweise
This getColumns method is specified by the getColumns method in the java.sql.DatabaseMetaData interface.
The result set returned by the getColumns method will contain the following information:
Name
Type
Description
TABLE_CAT
String
The catalog name.
TABLE_SCHEM
String
The table schema name.
TABLE_NAME
String
The table name.
COLUMN_NAME
String
The column name.
DATA_TYPE
short
The SQL data type from java.sql.Types.
TYPE_NAME
String
The name of the data type.
COLUMN_SIZE
int
The precision of the column.
BUFFER_LENGTH
int
Not supported by the JDBC driver.
DECIMAL_DIGITS
int
The scale of the column.
NUM_PREC_RADIX
int
The radix of the column.
NULLABLE
int
Indicates if the column is nullable. It can be one of the following values:
columnNoNulls (0)
columnNullable (1)
columnNullableUnknown (2)
REMARKS
String
The comments associated with the column.
Hinweis:
SQL Server always returns null for this column.
COLUMN_DEF
String
The default value of the column.
SQL_DATA_TYPE
int
Not supported by the JDBC driver.
SQL_DATETIME_SUB
int
Not supported by the JDBC driver.
CHAR_OCTET_LENGTH
int
The maximum number of bytes in the column.
ORDINAL_POSITION
int
The index of the column within the table.
IS_NULLABLE
String
Indicates if the column allows null values.
SCOPE_CATALOG
String
Not supported by the JDBC driver.
SCOPE_SCHEMA
String
Not supported by the JDBC driver.
SCOPE_TABLE
String
Not supported by the JDBC driver.
SOURCE_DATA_TYPE
short
Not supported by the JDBC driver.
Hinweis
For more information about the data returned by the getColumns method, see "sp_columns (Transact-SQL)" in SQL Server Books Online.
Beispiel
The following example demonstrates how to use the getColumns method to return information for the FirstName column in the Person.Contact table in the SQL Server 2005 AdventureWorks sample database.
public static void executeGetColumns(Connection con) {
try {
DatabaseMetaData dbmd = con.getMetaData();
ResultSet rs = dbmd.getColumns("AdventureWorks", "Person", "Contact", "FirstName");
ResultSetMetaData rsmd = rs.getMetaData();
// Display the result set data.
int cols = rsmd.getColumnCount();
while(rs.next()) {
for (int i = 1; i <= cols; i++) {
System.out.println(rs.getString(i));
}
}
rs.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
Siehe auch
Verweis
SQLServerDatabaseMetaData Class
Konzepte
SQLServerDatabaseMetaData Methods
SQLServerDatabaseMetaData Members