Java JDBC Database Metadata getPrimaryKey(DatabaseMetaData metadata, String tableName)

Description

Returns a table's primary key columns as a Set of strings.

License

Open Source License

Declaration

public static Set<String> getPrimaryKey(DatabaseMetaData metadata, String tableName) throws Exception 

Method Source Code

//package com.java2s;
//License from project: Open Source License 

import java.util.*;
import java.sql.*;

public class Main {
    private static final int PRIMARY_PK_COL_NAME = 4;

    /**//w  w w  .ja va2  s  .  com
     * Returns a table's primary key columns as a Set of strings.
     */
    public static Set<String> getPrimaryKey(DatabaseMetaData metadata, String tableName) throws Exception {
        Set<String> columns = new HashSet<String>();
        ResultSet keys = metadata.getPrimaryKeys(metadata.getConnection().getCatalog(), metadata.getUserName(),
                tableName);
        while (keys.next()) {
            columns.add(keys.getString(PRIMARY_PK_COL_NAME));
        }
        keys.close();
        return columns;
    }
}

Related

1. getDriverSpecificSettings(Connection connection, String defaultUnionColumnValue)
2. getForeignKeyDeferrability(int code)
3. getJDBCMajorVersion(Connection conn)
4. getNullableDescription(int type)
5. getOnly1PrimaryKey(Connection conn, String tableName)
6. getPrimaryKeyColumn(DatabaseMetaData md, String TableName)
7. getPrimaryKeyColumnNames(Connection connection, String tableName)
8. getPrimaryKeys(Connection conn, String tableName)
9. getQualifiedTableName(DatabaseMetaData dbmd, String catalog, String schema, String table, boolean useQuotes)