Referential integrity

From: surya <sai_surya_mp_at_yahoo.com>
Date: 23 May 2002 04:28:01 -0700
Message-ID: <e4fde6e1.0205230328.41485342_at_posting.google.com>


I am having tow tables

CREATE TABLE A1(
Id CHAR(4),
FileName CHAR(X),
primary key(Id)
)

CREATE TABLE A2(
Id CHAR(4) ,
FileName VARCHAR(250),
primary key(Id)
)

Whenever i update Table A1 column "FileName" with X the same record, with same Id,in Table A2 automatically need to be deleted. I need to maintain Referential integrity between both tables.  

Can you please suggest a Modified table quries for the above.

Thanks in advance
Surya Received on Thu May 23 2002 - 13:28:01 CEST

Original text of this message