SDU Tools: List empty user tables in SQL Server

When I've reviewing customer databases, I often come across tables that have been created by users, yet they are completely empty. Now that might be perfectly OK but sometimes, it's a mistake that should be cleaned up.

So, in our free SDU Tools for developers and DBAs, we added a tool that can look for user tables that are empty. No surprise, it's called ListEmptyTables.

It takes three parameters:

@DatabaseName sysname – the database to look into
@SchemasToList nvarchar(max) – a comma-delimited list of schemas to check (or 'ALL')
@TablesToList nvarchar(max) – a comma-delimited list of tables to check (or 'ALL')

Find out more

You can see it in action in the main image above, and in the video here:

Access to SDU Tools is one of the benefits of being an SDU Insider, along with access to our other free tools and eBooks. Please just visit here for more info:

http://sdutools.sqldownunder.com

 

Leave a Reply

Your email address will not be published.