• 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.