Another option would be replication, whereby you create the constraints on the replicated table. Not sure the feasibility of this since I no longer work with SQL Svr nor have I ever tried this.
Axton Grams On 5/4/06, Axton <[EMAIL PROTECTED]> wrote:
What about a db trigger that performs the validation and throws an exception in the event of an improper update/insert/delete? What particular aspects of PK/FK relationships are you looking to achieve? Cascading operations, integrity, constraints on allowable data, etc. Axton Grams On 5/4/06, Rusconi, Ignacio (I.) <[EMAIL PROTECTED]> wrote: > SQL 2000 don't accept cross reference within tables in different databses... > > So I was looking for an alternative solution for this. > > but it have to be within the DBMS > > Thanks > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black > Sent: Wednesday, May 03, 2006 2:01 PM > To: [email protected] > Subject: Re: Foreign key on table. > > Ignacio, > > With that said.... I think your best approach is to solve this with an > ARS methodology. Make the Application enforce the logic, not the > RDBMS. > > Add filters that verify the FK value in the other table. If filters > find a problem, then throw an ARS error. (Error might be, missing > value, non-unique value, etc...) > > To allow the Application to have access to the foreign table then you > likely need to look at either Direct SQL and/Or an ARS View form. > > -- > Carey Matthew Black > Remedy Skilled Professional (RSP) > ARS = Action Request System(Remedy) > > Solution = People + Process + Tools > Fast, Accurate, Cheap.... Pick two. > Never ascribe to malice, that which can be explained by incompetence. > > > > On 5/3/06, Axton <[EMAIL PROTECTED]> wrote: > > 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 > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org >
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
