Creating Foriegn Key

• rs

  SSCrazy

  Points: 2819

  More actions

  February 28, 2007 at 10:02 pm

  #69866

  I am trying to create foriegn key but getting the error

  USE TestDB

  GO

  ALTER TABLE [TableA]

  ADD CONSTARINT FK_MyTest FOREIGN KEY

  (

  [ID],[Name],[DOB]

  )

  REFERENCES [TableB]

  (

  [ID],[Name],[DOB]

  )

  GO

  Error Message

  Server: Msg 4902, Level 16, State 1, Line 2

  Cannot alter table 'TableA' because this table does not exist in database 'TestDB'

  Server: Msg 8140, Level 16, State 1, Line 2

  More than one key specified in column level FOREIGN KEY constraint, table 'TableA'.

  Any Help Please.

  RS.

   

• Dave Dustin

  Say Hey Kid

  Points: 688

  More actions

  March 1, 2007 at 1:30 am

  #692515

  First off, I'm assuming that TableA exists

  Can you post the DDL for the columns of the two tables?

   

  AucklandSQL User Group
  Independent SQL Server Consultant
  SQL Server MVP