Hello all!
I was wondering if a foreign key constraint will create an index like a primary key
constraint?
Thanks!
John PetersonThis is a multi-part message in MIME format.
--=_NextPart_000_0071_01C3DC30.22A93000
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit
Nope.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:eG2RnlF3DHA.1720@.TK2MSFTNGP10.phx.gbl...
(SQL Server 2000, SP3a)
Hello all!
I was wondering if a foreign key constraint will create an index like a
primary key
constraint?
Thanks!
John Peterson
--=_NextPart_000_0071_01C3DC30.22A93000
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Nope.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"John Peterson"
--=_NextPart_000_0071_01C3DC30.22A93000--|||Nope, you'll have to build one yourself.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:eG2RnlF3DHA.1720@.TK2MSFTNGP10.phx.gbl...
> (SQL Server 2000, SP3a)
> Hello all!
> I was wondering if a foreign key constraint will create an index like a
primary key
> constraint?
> Thanks!
> John Peterson
>|||Thanks Tom/Kalen! That's what I thought -- but wanted to double-check, as the CREATE
TABLE entry in BOL wasn't wholly specific on whether an index was created in the PK
context (though, it alludes to it later), and I thought maybe the FK description was
potentially similarly vague.
Thanks again!
John Peterson
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:eG2RnlF3DHA.1720@.TK2MSFTNGP10.phx.gbl...
> (SQL Server 2000, SP3a)
> Hello all!
> I was wondering if a foreign key constraint will create an index like a primary key
> constraint?
> Thanks!
> John Peterson
>
No comments:
Post a Comment