Saturday, February 25, 2012

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 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...Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"BATMAN" <BATMAN@.discussions.microsoft.com> wrote in message
news:C0D8618B-3836-4BD5-A7A6-14B91E91A87E@.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...

No comments:

Post a Comment