Get user table indexes, size and column order

  • Perry Whittle

    SSC Guru

    Points: 233859

    Comments posted to this topic are about the item Get user table indexes, size and column order

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    What a great script to get a quick table index list. I've saved this one. Thanks.

  • Perry Whittle

    SSC Guru

    Points: 233859

    thank you for your feedback, I'm hoping that users find the index column order data useful too

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • rw_ebox

    Say Hey Kid

    Points: 684

    The output looks pretty good.

    Thanks!

  • Alberto Turelli

    Old Hand

    Points: 359

    Very nice script, thank you!

    I only added a new column name, just to be aware of the schema (I make a heavy use of the schema separation for security purposes)

    SELECT

    SCHEMA_NAME(o.schema_id) + '.' + OBJECT_NAME(i.object_id) AS FullTableName,

    ...

Viewing 5 posts - 1 through 5 (of 5 total)

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