Constraint

From: mike <hillmw_at_charter.net>
Date: 24 Mar 2005 09:55:02 -0800
Message-ID: <1111686902.153455.240110@o13g2000cwo.googlegroups.com>

Trying to make a constraint

Instead of a constraint like this:

ALTER TABLE table_A

	ADD CONSTRAINT XFK_table_A_ID FOREIGN KEY (table_A_ID)
		REFERENCES table_B(table_B_ID)

I'd like to do something like:

ALTER TABLE table_A

	ADD CONSTRAINT XFK_table_A_ID FOREIGN KEY (table_A_ID)
		REFERENCES

table_B, table_C where table_B.id=table_C.id and table_C.level='0'

Does that make any sence?

Mike Received on Thu Mar 24 2005 - 11:55:02 CST