Jim,
The easiest way is to LIST TABLE tableName
It lists Table: Person
Description: 1 row = 1 person
Flags: CASCADE
Another way to see them all would be to:
OUTPUT fCascade.str
UNLOAD STRUCTURE; OUTPUT SCREEN
Then use an editor to search for the word 'cascade'
in the file fCascade.str.
It appears in the table definition line as:
CREATE TABLE `Product` CASCADE +
(`prID` INTEGER NOT NULL , + and so forth.
In the Sys_Indexes table there is a column containing '1'
for sys_primary_key. Only tables having a primary key
would be candidates for the CASCADE option.
The sys_referenced column contained a '1' for two of three
primary key columns in my database which have the cascade
option. However there were several others with a '1' which
did not. This referenced column is filled using the command:
ALTER TABLE `notes` ADD FOREIGN KEY +
`personNo` REFERENCES `person` ... followed by
error message definitions.
Randy Peterson
James Bentley wrote:
> Greetings all,
>
> Does anyone know how to determine if as table was defined
> with the CASCADE option by looking at such tables as SYS_TABLES,
> SYS_COLUMNS, SYS_INDEXES, etc. Please indicate which "sys"
> table and column along with value within that column.
>
> --
> Jim Bentley
> American Celiac Society
> [EMAIL PROTECTED] - email
> (973) 776-3900 x5029 - voicemail/fax
>
> __________________________________________________
> FREE voicemail, email, and fax...all in one place.
> Sign Up Now! http://www.onebox.com
