getFunctions Method (SQLServerDatabaseMetaData)
Retrieves a description of the system and user functions.
Hinweis
This feature is introduced starting with the Microsoft SQL Server JDBC Driver version 2.0.
public ResultSet getFunctions(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String functionNamePattern)
Parameter
catalog
The name of a catalog in the database. If it is an empty string "", the result includes the functions without a catalog. If it is null, the catalog name is not used for search.
schemaPattern
The name of a schema. If it is an empty string "", the result includes the functions without a schema. If it is null, the schema name is not used for search.
functionNamePattern
The name of a function.
Rückgabewert
A SQLServerResultSet object.
Ausnahmen
Hinweise
This getFunctions method is specified by the getFunctions method in the java.sql.DatabaseMetaData interface.
This method returns only the system and user functions that match the specified schema and function name.
Wichtig
The returned result set can contain functions that the calling user does not have permissions to execute.
Each function description includes the following columns:
Name | Type | Description |
---|---|---|
FUNCTION_CAT |
String |
The name of the database in which the function resides. |
FUNCTION_SCHEM |
String |
The name of the schema in which the function resides. |
FUNCTION_NAME |
String |
The name of the function. |
NUM_INPUT_PARAMS |
int |
Reserved for future use, currently returns a -1 value. |
NUM_OUTPUT_PARAMS |
int |
Reserved for future use, currently returns a -1 value. |
NUM_RESULT_SETS |
int |
Reserved for future use, currently returns a -1 value. |
REMARKS |
String |
The comments about the function. |
FUNCTION_TYPE |
short |
The type of the function. It can be one of the following values: SQL_PT_UNKNOWN (0) SQL_PT_PROCEDURE (1) SQL_PT_FUNCTION (2) |
All the descriptions in the returned result set are ordered by FUNCTION_CAT, FUNCTION_SCHEM, FUNCTION_NAME, and SPECIFIC_NAME.
Siehe auch
Referenz
SQLServerDatabaseMetaData Class
Konzepte
SQLServerDatabaseMetaData Methods
SQLServerDatabaseMetaData Members