--- title: "getMaxColumnsInIndex Method (SQLServerDatabaseMetaData) | 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: - "SQLServerDatabaseMetaData.getMaxColumnsInIndex" apilocation: - "sqljdbc.jar" apitype: "Assembly" ms.assetid: 108f0e2c-7dc5-4195-8248-0758a75a314e caps.latest.revision: 7 author: MightyPen ms.author: genemi manager: craigg --- # getMaxColumnsInIndex Method (SQLServerDatabaseMetaData) [!INCLUDE[Driver_JDBC_Download](../../../includes/driver_jdbc_download.md)] Retrieves the maximum number of columns that this database allows in an index. ## Syntax ``` public int getMaxColumnsInIndex() ``` ## Return Value An **int** that indicates the maximum number of columns allowed. ## Exceptions [SQLServerException](../../../connect/jdbc/reference/sqlserverexception-class.md) ## Remarks This getMaxColumnsInIndex method is specified by the getMaxColumnsInIndex 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)