Primary and ForeignKey relations

• ramana3327

  SSCoach

  Points: 19700

  More actions

  December 14, 2013 at 12:29 pm

  #283593

  How can you create foreign key relation to the same table which contains primary key.

• pietlinden

  SSC Guru

  Points: 63421

  More actions

  December 14, 2013 at 4:44 pm

  #1673493

  ramana3327 (12/14/2013)

  ---

  How can you create foreign key relation to the same table which contains primary key.

  So you're doing a self-join? Like in an Employee/Manager scenario?

  See this article: http://msdn.microsoft.com/en-us/library/ms190273.aspx

  Section E.

  there are examples of creating primary and foreign key constraints.

• kumar1

  Ten Centuries

  Points: 1185

  More actions

  December 16, 2013 at 10:06 am

  #1673786

  How?

  Yep, I can create like below...

  CREATE TABLE Emp(

  EmpID INT PRIMARY KEY,

  Emp_Name VARCHAR(100),

  Emp_JoinDate DATE,

  Emp_Salary Money,

  Emp_Designation Varchar(50),

  Emp_ManagerID INT FOREIGN KEY REFERENCES Employee(EmpID)

  )

  You may get issues while inserting into Emp_ManagerID , you may use null value for that.