--- title: "getParameterMode Method (SQLServerParameterMetaData) | Microsoft Docs" ms.custom: "" ms.date: "01/19/2017" ms.prod: "sql" ms.prod_service: connectivity ms.reviewer: "" ms.suite: "sql" ms.technology: connectivity ms.tgt_pltfrm: "" ms.topic: conceptual apiname: - "SQLServerParameterMetaData.getParameterMode" apilocation: - "sqljdbc.jar" apitype: "Assembly" ms.assetid: d93c9b70-18c2-44bb-a6de-70a7e940d806 caps.latest.revision: 8 author: MightyPen ms.author: genemi manager: craigg --- # getParameterMode Method (SQLServerParameterMetaData) [!INCLUDE[Driver_JDBC_Download](../../../includes/driver_jdbc_download.md)] Retrieves the mode of the designated parameter. ## Syntax ``` public int getParameterMode(int param) ``` #### Parameters *param* An **int** that indicates parameter index. ## Return Value An **int** that indicates the mode of the designated parameter, which can be one of the following values: ParameterMetaData.parameterModeIn ParameterMetaData.parameterModeInOut ParameterMetaData.parameterModeOut ParameterMetaData.parameterModeUnknown ## Exceptions [SQLServerException](../../../connect/jdbc/reference/sqlserverexception-class.md) ## Remarks This getParameterMode method is specified by the getParameterMode method in the java.sql.ParameterMetaData interface. ## See Also [SQLServerParameterMetaData Methods](../../../connect/jdbc/reference/sqlserverparametermetadata-methods.md) [SQLServerParameterMetaData Members](../../../connect/jdbc/reference/sqlserverparametermetadata-members.md) [SQLServerParameterMetaData Class](../../../connect/jdbc/reference/sqlserverparametermetadata-class.md)