getSchemas Method (String, String)
Retrieves the schema names that are available in the current database by using the specified catalog name and the schema name.
참고
This feature is introduced starting with the Microsoft SQL Server JDBC Driver version 2.0.
public ResultSet getSchemas(java.lang.String catalog,
java.lang.String schemaPattern)
매개 변수
catalog
The name of a catalog in the database. If it is an empty string "", the result includes the schemas without a catalog. If it is null, the catalog name is not used for search.
schemaPattern
The name of a schema. If it is null, the schema name is not used for search.
반환 값
A SQLServerResultSet object.
예외
주의
This getSchemas method is specified by the getSchemas method in the java.sql.DatabaseMetaData interface.
The result set returned by the getSchemas method contains the following information:
| Name | Type | Description |
|---|---|---|
TABLE_SCHEM |
String |
The name of the schema. |
TABLE_CATALOG |
String |
The catalog name for the schema. |
The results are ordered by TABLE_CATALOG and then TABLE_SCHEM. Each row has TABLE_SCHEM as the first column and TABLE_CATALOG as the second column.
참고
참조
SQLServerDatabaseMetaData Class
개념
SQLServerDatabaseMetaData Methods
SQLServerDatabaseMetaData Members