Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Identifying Unused Tables with T-SQL

Learn how to easily identify unused Tables.


advertisement

You can identify unused Tables in the following way:

; with Unused (TableName , RowCount, DateCreated, DateModified)

AS (

SELECT unusedTable.name AS TableName

,PS.row_count AS RowCount

,unusedTable.create_date AS DateCreated

,unusedTable.modify_date AS DateModified

FROM sys.all_objects UnusedTable

JOIN sys.dm_db_partition_stats PS ON OBJECT_NAME(PS.object_id)=unusedTable.name

WHERE unusedTable.type ='U'

AND NOT EXISTS (SELECT OBJECT_ID

FROM sys.dm_db_index_usage_stats

WHERE OBJECT_ID = unusedTable.object_id )

)

SELECT TableName , RowCount, DateCreated, DateModified

FROM Unused

ORDER BY RowCount

 

Visit the DevX Tip Bank

 





   
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date