Home » RDBMS Server » Server Administration » How to create Unique Index on columns from two different tables?
How to create Unique Index on columns from two different tables? [message #52612] Wed, 31 July 2002 15:45 Go to next message
Bismi Rahaman
Messages: 1
Registered: July 2002
Junior Member
Hi - I have two tables A(a char(1), b char(1))
and B(A number, B Char(1)).

I would like to ensure that the combination of A.a and B.a be Unique. I would like to enforce this at table level with out creating Check Constraints or Creating DataBase triggers.

Is there any ways of ensuring that the Data that goes in is Unique!

Thanks,
-Bismi

Report message to a moderator

Re: How to create Unique Index on columns from two different tables? [message #52621 is a reply to message #52612] Thu, 01 August 2002 08:57 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Interesting question - but I don't see how you can achieve it.

Report message to a moderator

Previous Topic: Table Design Confution(URGENT)
Next Topic: I want to move out SYSTEM objects from TEMP tablespace
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 14:53:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.