0 - 4 of 4 tags for foreign key

Hi,
 
is there any information provided by the data dictionary which allows one to differentiate between the 3 types of foreign keys supported by Teradata?
 
(1) Row level
(2) 'With check option'
(3) 'With no check option'
Thanks,
 
Andrew.

 One of our data modelers came to me with the following scenario.  He is creating two tables and defining a foreign key on one that references the other.
CREATE  TABLE EDWSPACE.AMK_ACCT_ANC
(              ACCT_ID              INTEGER NOT NULL ,
                LOAD_TS              TIMESTAMP NOT NULL
)

Hello,
I have a strange error.
I am creating one table with foreign key on the same table :

CREATE TABLE TEST_B
(TID INTEGER NOT NULL,
PASSRESETDATE TIMESTAMP,
BACTIVE BYTEINT NOT NULL,
TEST_ID INTEGER,
CONSTRAINT PK_TEST_B PRIMARY KEY (TID));

ALTER TABLE TEST_B
ADD CONSTRAINT FK_TEST_B FOREIGN KEY (TEST_ID)
REFERENCES WITH CHECK OPTION TEST_B(TID);

I insert some data with java program :

PreparedStatement pstmt =null;
pstmt= conn.prepareStatement("INSERT INTO TEST_B (TID,BACTIVE,PASSRESETDATE,TEST_ID) VALUES (?,?,?,?)");
for(int i=1;i<3;i++){

Until you have Teradata V13 Statistics Wizard Easy Feature available for your Teradata installation, here is a set of stored procedures that will generate and/or run collect statistics statements based on a set of index, column and referential integrity rules.