<html> <head> <title>Constants' Group KeyRule</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimainnone">Use</td> <td class="navimainnone">Devguide</td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub"><a href="#Constants" class="navisub">Constants</a></td> <td class="navisub"><a href="#ConstantDetails" class="navisub">Constants' Details</a></td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">sdbc</a> :: </p> </td> </tr> <tr> <td class="title">constants group KeyRule</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>determines the rules for foreign key constraints. </dd> </dl> </td> </tr> </table> <hr> <a name="Constants"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Constants</td> </tr> <tr> <td class="imsum_left"><a href="#CASCADE">CASCADE</a></td> <td class="imsum_right">a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </td> </tr> <tr> <td class="imsum_left"><a href="#RESTRICT">RESTRICT</a></td> <td class="imsum_right">a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </td> </tr> <tr> <td class="imsum_left"><a href="#SET_NULL">SET_NULL</a></td> <td class="imsum_right">a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </td> </tr> <tr> <td class="imsum_left"><a href="#NO_ACTION">NO_ACTION</a></td> <td class="imsum_right">a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </td> </tr> <tr> <td class="imsum_left"><a href="#SET_DEFAULT">SET_DEFAULT</a></td> <td class="imsum_right">a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </td> </tr> </table> <a name="ConstantDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Constants' Details</td> </tr> <tr> <td class="imdetail"><a name="CASCADE" class="membertitle">CASCADE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>CASCADE</b> = 0;<hr> <dl> <dt><b>Description</b></dt> <dd>a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </dd> <dd><P> For the column <code>UPDATE_RULE</code> , it indicates that when the primary key is updated, the foreign key (imported key) is changed to agree with it. </P> <P> For the column <code>DELETE_RULE</code> , it indicates that when the primary key is deleted, rows that imported that key are deleted. </P> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="RESTRICT" class="membertitle">RESTRICT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>RESTRICT</b> = 1;<hr> <dl> <dt><b>Description</b></dt> <dd>a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </dd> <dd><P> For the column <code>UPDATE_RULE</code> , it indicates that a primary key may not be updated if it has been imported by another table as a foreign key. </P> <P> For the column <code>DELETE_RULE</code> , it indicates that a primary key may not be deleted if it has been imported by another table as a foreign key. </P> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SET_NULL" class="membertitle">SET_NULL</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>SET_NULL</b> = 2;<hr> <dl> <dt><b>Description</b></dt> <dd>a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </dd> <dd><P> For the columns <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> , it indicates that when the primary key is updated or deleted, the foreign key (imported key) is changed to <code>NULL</code>. </P> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="NO_ACTION" class="membertitle">NO_ACTION</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>NO_ACTION</b> = 3;<hr> <dl> <dt><b>Description</b></dt> <dd>a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </dd> <dd><P> For the columns <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> , it indicates that if the primary key has been imported, it cannot be updated or deleted. </P> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SET_DEFAULT" class="membertitle">SET_DEFAULT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>SET_DEFAULT</b> = 4;<hr> <dl> <dt><b>Description</b></dt> <dd>a possible value for the column's <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> in the <a href="XResultSet.html">XResultSet</a> objects returned by the methods <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getImportedKeys">getImportedKeys()</a> , <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getExportedKeys">getExportedKeys()</a> , and <a href="XDatabaseMetaData.html">XDatabaseMetaData</a>::<a href="XDatabaseMetaData.html#getCrossReference">getCrossReference()</a> . </dd> <dd><P> For the columns <code>UPDATE_RULE</code> and <code>DELETE_RULE</code> , it indicates that if the primary key is updated or deleted, the foreign key (imported key) is set to the default value. </P> </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2010 Sun Microsystems, Inc.</p> </div> <!-- id="adc-idlref" --> </body> </html>