Referential Integrity
From: surya <sai_surya_mp_at_yahoo.com>
Date: 23 May 2002 01:59:46 -0700
Message-ID: <e4fde6e1.0205230059.20c7c9db_at_posting.google.com>
Date: 23 May 2002 01:59:46 -0700
Message-ID: <e4fde6e1.0205230059.20c7c9db_at_posting.google.com>
I am having tow Tables like this.
Table1(Id (Char),Name(Varchar))
Primary Key is "Name" for both tables.
My question is i want to maintain referential integrity between the
above tables.
Whenever i am updating a record of Table1 column "Id" with value "X" i
need to delte the record in Table2.
Can suggest a "Create table queries".
Thanks in advance
Table2(Name(Varchar))
Surya
Received on Thu May 23 2002 - 10:59:46 CEST