DBCC DBREINDEX

Does "DBCC DBREINDEX" include pk's?
The reason I ask is because I know that pk's are first and formost a
constraint... But I also am aware that an index is created on the pk and th
e
pk index nam is stored in sysindexes.
So I guess I'm just verifying that DBCC DBREINDEX does include the pk's inde
x.
Thanks...Yes, if it was declared as a PK constraint it will have an index behind it
to enforce it. And yes DBREINDEX will treat it like any other index.
Andrew J. Kelly SQL MVP
"BATMAN" <BATMAN@.discussions.microsoft.com> wrote in message
news:6E625833-97A6-4A54-B263-D427B10B220E@.microsoft.com...
> Does "DBCC DBREINDEX" include pk's?
> The reason I ask is because I know that pk's are first and formost a
> constraint... But I also am aware that an index is created on the pk and
> the
> pk index nam is stored in sysindexes.
> So I guess I'm just verifying that DBCC DBREINDEX does include the pk's
> index.
> Thanks...
>|||Thanks...
Does DBCC DBREINDEX use the SORT_IN_TEMPDB option?
"Andrew J. Kelly" wrote:

> Yes, if it was declared as a PK constraint it will have an index behind it
> to enforce it. And yes DBREINDEX will treat it like any other index.
> --
> Andrew J. Kelly SQL MVP
>
> "BATMAN" <BATMAN@.discussions.microsoft.com> wrote in message
> news:6E625833-97A6-4A54-B263-D427B10B220E@.microsoft.com...
>
>|||Not in 2000 but ALTER INDEX has that option in 2005.
Andrew J. Kelly SQL MVP
"BATMAN" <BATMAN@.discussions.microsoft.com> wrote in message
news:76E334B6-42A4-44AA-B608-CF0B2B99C2D6@.microsoft.com...
> Thanks...
> Does DBCC DBREINDEX use the SORT_IN_TEMPDB option?
>
> "Andrew J. Kelly" wrote:
>