Skip to content

getfunctions-method-sqlserverdatabasemetadata.md

Latest commit

 

History

History
71 lines (50 loc) · 2.88 KB

getfunctions-method-sqlserverdatabasemetadata.md

File metadata and controls

71 lines (50 loc) · 2.88 KB
title getFunctions Method (SQLServerDatabaseMetaData)
description getFunctions Method (SQLServerDatabaseMetaData)
author David-Engel
ms.author davidengel
ms.date 01/19/2017
ms.service sql
ms.subservice connectivity
ms.topic reference

getFunctions Method (SQLServerDatabaseMetaData)

[!INCLUDEDriver_JDBC_Download]

Retrieves a description of the system and user functions.

Syntax

  
public ResultSet getFunctions(java.lang.String catalog,  
                       java.lang.String schemaPattern,  
                       java.lang.String functionNamePattern)

Parameters

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.

Return Value

A SQLServerResultSet object.

Exceptions

SQLServerException

Remarks

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.

Important

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.

See Also

SQLServerDatabaseMetaData Members
SQLServerDatabaseMetaData Class