Quick table size information

Question

Post reply

Quick table size information

Xedni

SSCertifiable

Points: 6951
More actions
June 10, 2016 at 2:50 pm

#400261

Comments posted to this topic are about the item Quick table size information
Executive Junior Cowboy Developer, Esq.[/url]

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

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

Robert Sterbal SSChampion Points: 11047 More actions · Answer 1

What are your restrictions on republishing this script?

412-977-3526 call/text

sequelgarrett SSC Eights! Points: 816 More actions · Answer 2

This only works within the dbo schema. To have it work with all tables, you'd need to change line 39 to do something like this:

select quotename(s.name) + '.' + quotename(t.name)

from sys.tables t

inner join sys.schemas s

on t.schema_id = s.schema_id

Xedni SSCertifiable Points: 6951 More actions · Answer 3

robert.sterbal 56890 (7/4/2016)
What are your restrictions on republishing this script?

Use it to your heart's content.

Executive Junior Cowboy Developer, Esq.[/url]

Xedni SSCertifiable Points: 6951 More actions · Answer 4

sequelgarrett (7/5/2016)
This only works within the dbo schema. To have it work with all tables, you'd need to change line 39 to do something like this:

Thanks for pointing that out.

Executive Junior Cowboy Developer, Esq.[/url]