SQL Table Size and last modified date

[imaran_669]

Hi Comunity, im doing a process to do some manteinance to my SQL server. Im currently listing all tables with this SQL comand:

SELECT * FROM information_schema.tables

Im wondering if its posible to:

1) List the size (disk space) of those tables.

2) Check the last time they were modified

Is this posible?

Regards, 

[danilang]

Hi @imaran_669 

Assuming the size and last modified date is returned by this query, you can put this query into an Input Data tool and the results will be there.  This requires that the account that you're running with has permission to read information_schema.tables.

If the data isn't returned, then you need to do some digging into the specifics of SQL server.  For instance, this page gives a query to return the table sizes.

Dan