is this?select owner, table_name, constraint_name, constraint_type, search_condition from user_constraints where table_name='xxxxx' and constraint_type='p';
我同意: gzwrj(我无知,所以我有智慧.)说的,但有一点, constraint_type='P'中的"P"为大写不是小写,否则oracle中不认. select owner, table_name, constraint_name, constraint_type, search_condition from user_constraints where table_name='PORTLETENTRY_DTDMAP' and constraint_type='P';
try {
con = DriverManager.getConnection(url, "myLogin", "myPassword");
stmt = con.createStatement();
stmt.executeUpdate(createString);
DatabaseMetaData dbmd = con.getMetaData();
ResultSet rs = dbmd.getPrimaryKeys(null, null, "TableName");
while (rs.next()) {
String name = rs.getString("TABLE_NAME");
String columnName = rs.getString("COLUMN_NAME");
String keySeq = rs.getString("KEY_SEQ");
String pkName = rs.getString("PK_NAME");
System.out.println("table name : " + name);
System.out.println("column name: " + columnName);
System.out.println("sequence in key: " + keySeq);
System.out.println("primary key name: " + pkName);
System.out.println("");
}
}
……
select owner, table_name, constraint_name, constraint_type, search_condition from user_constraints where table_name='PORTLETENTRY_DTDMAP' and constraint_type='P';