Constants' Group KeyRule

Content for OpenOffice.org version 3.3.

Overview

Module

Use

Devguide

Index

Constants

Constants' Details

:: com :: sun :: star :: sdbc ::

constants group KeyRule

Description: determines the rules for foreign key constraints.

Constants
CASCADE	a possible value for the column's `UPDATE_RULE` and `DELETE_RULE` in the XResultSet objects returned by the methods XDatabaseMetaData::getImportedKeys() , XDatabaseMetaData::getExportedKeys() , and XDatabaseMetaData::getCrossReference() .
RESTRICT	a possible value for the column's `UPDATE_RULE` and `DELETE_RULE` in the XResultSet objects returned by the methods XDatabaseMetaData::getImportedKeys() , XDatabaseMetaData::getExportedKeys() , and XDatabaseMetaData::getCrossReference() .
SET_NULL	a possible value for the column's `UPDATE_RULE` and `DELETE_RULE` in the XResultSet objects returned by the methods XDatabaseMetaData::getImportedKeys() , XDatabaseMetaData::getExportedKeys() , and XDatabaseMetaData::getCrossReference() .
NO_ACTION	a possible value for the column's `UPDATE_RULE` and `DELETE_RULE` in the XResultSet objects returned by the methods XDatabaseMetaData::getImportedKeys() , XDatabaseMetaData::getExportedKeys() , and XDatabaseMetaData::getCrossReference() .
SET_DEFAULT	a possible value for the column's `UPDATE_RULE` and `DELETE_RULE` in the XResultSet objects returned by the methods XDatabaseMetaData::getImportedKeys() , XDatabaseMetaData::getExportedKeys() , and XDatabaseMetaData::getCrossReference() .

Constants' Details

CASCADE

const long CASCADE = 0; Description a possible value for the column's `UPDATE_RULE` and `DELETE_RULE` in the XResultSet objects returned by the methods XDatabaseMetaData::getImportedKeys() , XDatabaseMetaData::getExportedKeys() , and XDatabaseMetaData::getCrossReference() . For the column `UPDATE_RULE` , it indicates that when the primary key is updated, the foreign key (imported key) is changed to agree with it. For the column `DELETE_RULE` , it indicates that when the primary key is deleted, rows that imported that key are deleted.

RESTRICT

const long RESTRICT = 1; Description a possible value for the column's `UPDATE_RULE` and `DELETE_RULE` in the XResultSet objects returned by the methods XDatabaseMetaData::getImportedKeys() , XDatabaseMetaData::getExportedKeys() , and XDatabaseMetaData::getCrossReference() . For the column `UPDATE_RULE` , it indicates that a primary key may not be updated if it has been imported by another table as a foreign key. For the column `DELETE_RULE` , it indicates that a primary key may not be deleted if it has been imported by another table as a foreign key.

SET_NULL

const long SET_NULL = 2; Description a possible value for the column's `UPDATE_RULE` and `DELETE_RULE` in the XResultSet objects returned by the methods XDatabaseMetaData::getImportedKeys() , XDatabaseMetaData::getExportedKeys() , and XDatabaseMetaData::getCrossReference() . For the columns `UPDATE_RULE` and `DELETE_RULE` , it indicates that when the primary key is updated or deleted, the foreign key (imported key) is changed to `NULL`.

NO_ACTION

const long NO_ACTION = 3; Description a possible value for the column's `UPDATE_RULE` and `DELETE_RULE` in the XResultSet objects returned by the methods XDatabaseMetaData::getImportedKeys() , XDatabaseMetaData::getExportedKeys() , and XDatabaseMetaData::getCrossReference() . For the columns `UPDATE_RULE` and `DELETE_RULE` , it indicates that if the primary key has been imported, it cannot be updated or deleted.

SET_DEFAULT

const long SET_DEFAULT = 4; Description a possible value for the column's `UPDATE_RULE` and `DELETE_RULE` in the XResultSet objects returned by the methods XDatabaseMetaData::getImportedKeys() , XDatabaseMetaData::getExportedKeys() , and XDatabaseMetaData::getCrossReference() . For the columns `UPDATE_RULE` and `DELETE_RULE` , it indicates that if the primary key is updated or deleted, the foreign key (imported key) is set to the default value.

Top of Page

Copyright © 1995, 2010, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous