Get user table indexes, size and column order

Question

Viewing 5 posts - 1 through 5 (of 5 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: 234040 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 SSC Eights! Points: 804 More actions · Answer 3

SSC Eights!

Points: 804

October 8, 2015 at 9:52 am

The output looks pretty good.

Thanks!

Alberto Turelli SSC-Addicted Points: 458 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,

...

Cookies on SQLServerCentral