Constants' Group KeyRule

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 © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.

API

SDK

Tips ‘n’ Tricks

Miscellaneous