--- title: "getUDTs Method (SQLServerDatabaseMetaData) | Microsoft Docs" ms.custom: "" ms.date: "01/19/2017" ms.prod: sql ms.prod_service: connectivity ms.reviewer: "" ms.technology: connectivity ms.topic: conceptual apiname: - "SQLServerDatabaseMetaData.getUDTs" apilocation: - "sqljdbc.jar" apitype: "Assembly" ms.assetid: c4396453-dcb0-4132-8325-06b3c7896b3b author: David-Engel ms.author: v-daenge --- # getUDTs Method (SQLServerDatabaseMetaData) [!INCLUDE[Driver_JDBC_Download](../../../includes/driver_jdbc_download.md)] Retrieves a description of the user-defined types that are defined in a particular schema. > [!NOTE] > This method is not currently supported with [!INCLUDE[jdbcNoVersion](../../../includes/jdbcnoversion_md.md)]. When used, this method will always return an empty result set. ## Syntax ``` public java.sql.ResultSet getUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types) ``` #### Parameters *catalog* A **String** that contains the catalog name. *schemaPattern* A **String** that contains the schema name pattern. *typeNamePattern* A **String** that contains the type name pattern. *types* An array of ints that contain the data types to include. Null indicates that all types should be included. ## Return Value A [SQLServerResultSet](../../../connect/jdbc/reference/sqlserverresultset-class.md) object. ## Exceptions [SQLServerException](../../../connect/jdbc/reference/sqlserverexception-class.md) ## Remarks This getUDTs method is specified by the getUDTs method in the java.sql.DatabaseMetaData interface. ## See Also [SQLServerDatabaseMetaData Methods](../../../connect/jdbc/reference/sqlserverdatabasemetadata-methods.md) [SQLServerDatabaseMetaData Members](../../../connect/jdbc/reference/sqlserverdatabasemetadata-members.md) [SQLServerDatabaseMetaData Class](../../../connect/jdbc/reference/sqlserverdatabasemetadata-class.md)