Foreign Key

Results 1 to 2 of 2

Thread: Foreign Key

  1. #1
    Join Date
    Dec 1969

    Default Foreign Key

    How do you assign a Foreign Key in SQL Server 7? When I right click the field name is design view I only see an option for Primary key, not foreign key.<BR>Thanks.

  2. #2
    Freddie Spencer Guest

    Default RE: Foreign Key

    Try viewing the linked tables in the database diagram and then drag the primary key field from one table into its corresponding foreign key field in the other table.

Posting Permissions

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