Results 1 to 3 of 3

Thread: Script

  1. #1
    Join Date
    Jan 2004
    Posts
    67

    Unanswered: Script

    Hi

    I have a table that has 3 columns A,B,C.
    Each of these columns are Foreign Keys to some Parent Table.

    Can someone give me the SCRIPT for creating a Table with these constraints.

    Thanks
    Shankar

  2. #2
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    89

    Re: Script

    Originally posted by shankar
    Hi

    I have a table that has 3 columns A,B,C.
    Each of these columns are Foreign Keys to some Parent Table.

    Can someone give me the SCRIPT for creating a Table with these constraints.

    Thanks
    Shankar

    create table table_name
    (A varchar2(10),
    B varchar2(10),
    C varchar2(10),
    foreign key A references parent_table(column_name1),
    foreign key B references parent_table(column_name2),
    foreign key C references parent_table(column_name3)
    )
    Thanks and Regards,

    Praveen Pulikunnu

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    download TOAD for free and it will do it for you.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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