How to check how many indexes created on a table

  • is there any command to count how many indexes

  • Information regarding indexes for each table can be found in the sys.indexes view.

    select * --- make this COUNT(*) at your leisure

    from sys.indexes

    where [object_ID] = object_id( N'MarketStats')

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • Thank you .

    Cheers . 😀

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply