Home Forums Article Discussions Article Discussions by Author Discuss content posted by Phil Factor Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it? RE: Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?

  • August 4, 2014 at 1:28 am

    #1734743

    Hi,

    Yeah this is a very straightforward question but in the context of SQL Server. But will be bit confusing to those who work on other RDBMS products such as MySQL InnoDB. But, for those who work rigorously on MS SQL Server this is just a straightforward question worth of 1 point.