Get user table indexes, size and column order

Question

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

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 1

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

Perry Whittle SSC Guru Points: 233821 More actions · Answer 2

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 Right there with Babe Points: 797 More actions · Answer 3

Right there with Babe

Points: 797

October 8, 2015 at 9:52 am

The output looks pretty good.

Thanks!

Alberto Turelli Old Hand Points: 391 More actions · Answer 4

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,

...