Foreign keys are a foreign concept when it comes to ARS.
At the db level you can do whatever you please, though there may be
unintended consequences when doing so on ARS built tables:
- consider that certain ARAdmin operations drop and recreate the table
(alter decimal field precision, etc.)
- consider that if a user violates a constraint enforced by Oracle,
Remedy will return the appropriate ORA-xxxxx error to the user; traps
for these types of errors are non-existent.
Axton Grams
On 5/3/06, Rusconi, Ignacio (I.) <[EMAIL PROTECTED]> wrote:
**
Does anybody knows how to implement a foreign key to another database in the
same instance….?
SQL 2000
ARS 5.01
Ignacio G. Rusconi
Data Base Administrator
Ford Argentina-TeleTech
:.4756-9367.:
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Web. http://pacheco.ba.ford.com/pl/9898
¿Sentiste un Ford últimamente?
STRICTLY CONFIDENTIAL. The contents of this e-mail and any attachments are
strictly confidential and property of Ford Argentina S.C.A. They may not be
used or disclosed by someone who is not a named recipient. If you have
received this e-mail in error please notify the sender by replying to this
email inserting the word "Misdirected" as the message and delete the present
message.__20060125_______________________This posting was
submitted with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
