Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    USA
    Posts
    33

    Unanswered: Relationships accross schemas...

    Hi Friends,

    I want to create a Referential Constraint on a table. The table in question exists in Schema_1 the Referential Constraint parent table is in schema_2.

    My question is, what are the ways to create this kind of constraint.

    Not: Both the Schemas are in the same database server instance.

    Thanks,
    Amit
    A friend in need is a friend in deed

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Grant REFERENCES from parent table to child and follow syntax to create referential integrity. Don't forget to include schema name along with table name (for example, 'scott.dept').

  3. #3
    Join Date
    Dec 2003
    Location
    USA
    Posts
    33
    Was it so simple?

    Thanks my friend, that worked.
    A friend in need is a friend in deed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •