public class PrimaryKey { static String user = "user"; static String pass = "password"; static String host = "localhost"; static String db = "Personal"; static String table = "Angestellte"; public static void main(String[] args) { String url = "jdbc:mysql://" + host + "/" + db; getKeys(url); } public static void getKeys(String url) { try(Connection connection = DriverManager .getConnection(url, user, pass)) { Class.forName("com.mysql.cj.jdbc.Driver"); DatabaseMetaData dbmd = connection.getMetaData(); ResultSet rs = dbmd.getPrimaryKeys(null, null, table); if (rs.next()) { do { System.out.println("Primary Key Name: " + rs.getString(6) + ", Primary Key Nummer: " + rs.getString(5) + ", Column: " + rs.getString(4)); }while(rs.next()); }else { System.out.println("No keys found"); } } catch (SQLException e) { System.out.println("Fehler bei Tabellenabfrage: " + e); return; } catch (ClassNotFoundException e) { e.printStackTrace(); } } }