Posted by Tom van Stiphout on 09/23/07 04:28

On Fri, 21 Sep 2007 19:51:14 -0000, "bobdurie@gmail.com"
<bobdurie@gmail.com> wrote:

Microsoft Access does this, when you create a relationship between two
tables.
Check with sysindexes to see if SQL Server does this too.

-Tom.


>If i create a simple table with a foreign key constraint, does it
>create an implicit index on that given ID? I've been told this is
>done in some databases, but i need to know for sure if SQL Server does
>it. Has anyone heard of this before, on any other databses perhaps?
>
>Heres an example of how the foreign key constraint is being added:
>
>ALTER TABLE [dbo].[administrators] WITH CHECK ADD CONSTRAINT
>[FPSLUFSUOXZGAJOJ] FOREIGN KEY([AdministratorRoleID])
>REFERENCES [dbo].[administratorroles] ([AdministratorRoleID])
>
>My initial testing seems to indicate adding an index on the foreign
>key column helps, but i need to know for sure. Any insight would be
>greatly appreciated!
>
>Bob

• Next in forum: Re: Do foreign keys generate implicit indexes?
• Prev in forum: Re: find unique identifier through multiple tables
• Thread view: Re: Do foreign keys generate implicit indexes?

[Reply to this message]