getExportedKeys Method (SQLServerDatabaseMetaData)

Retrieves a description of the foreign key columns that reference the primary key columns of the given table.

public java.sql.ResultSet getExportedKeys(java.lang.String cat,
                                          java.lang.String schema,
                                          java.lang.String table)

Parámetros

cat

A String that contains the catalog name.

schema

A String that contains the schema name.

table

A String that contains the table name.

Valor devuelto

A SQLServerResultSet object.

Excepciones

SQLServerException

Notas

This getExportedKeys method is specified by the getExportedKeys method in the java.sql.DatabaseMetaData interface.

The result set returned by the getExportedKeys method will contain the following information:

Name	Type	Description
PKTABLE_CAT	String	The name of the catalog that contains the primary key table.
PKTABLE_SCHEM	String	The name of the schema of the primary key table.
PKTABLE_NAME	String	The name of the primary key table.
PKCOLUMN_NAME	String	The column name of the primary key.
FKTABLE_CAT	String	The name of the catalog that contains the foreign key table.
FKTABLE_SCHEM	String	The name of the schema of the foreign key table.
FKTABLE_NAME	String	The name of the foreign key table.
FKCOLUMN_NAME	String	The column name of the foreign key.
KEY_SEQ	short	The sequence number of the column in a multicolumn primary key.
UPDATE_RULE	short	The action applied to the foreign key when the SQL operation is an update. It can be one of the following values: importedKeyNoAction (3) importedKeyCascade (0) importedKeySetNull (2) importedKeySetDefault (4) importedKeyRestrict (1)
DELETE_RULE	short	The action applied to the foreign key when the SQL operation is a deletion. It can be one of the following values: importedKeyNoAction (3) importedKeyCascade (0) importedKeySetNull (2) importedKeySetDefault (4) importedKeyRestrict (1)
FK_NAME	String	The name of the foreign key.
PK_NAME	String	The name of the primary key.
DEFERRABILITY	short	Indicates if the evaluation of the foreign key constraint can be deferred until a commit. It can be one of the following values: importedKeyInitiallyDeferred (5) importedKeyInitiallyImmediate (6) importedKeyNotDeferrable (7)

Nota

For more information about the data returned by the getExportedKeys method, see "sp_fkeys (Transact-SQL)" in SQL Server Books Online.

Ejemplo

The following example demonstrates how to use the getExportedKeys method to return information about all the foreign keys that reference the primary keys of the Person.Contact table in the SQL Server 2005 AdventureWorks sample database.

public static void executeGetExportedKeys(Connection con) {
   try {
      DatabaseMetaData dbmd = con.getMetaData();
      ResultSet rs = dbmd.getExportedKeys("AdventureWorks", "Person", "Contact");
      ResultSetMetaData rsmd = rs.getMetaData();

      // Display the result set data.
      int cols = rsmd.getColumnCount();
      while(rs.next()) {
         for (int i = 1; i <= cols; i++) {
            System.out.println(rs.getString(i));
         }
      }
      rs.close();
   } 

   catch (Exception e) {
      e.printStackTrace();
   }
}

Vea también

Referencia

SQLServerDatabaseMetaData Class

Conceptos

SQLServerDatabaseMetaData Methods
SQLServerDatabaseMetaData Members