Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cutepraba
Yak Posting Veteran
53 Posts |
 Posted - 2009-03-30 : 07:24:01
|
| Is there anyway to find unused tables(Last 1 year). I need to delete all the unused tables from my db.Thanks.____________Praba |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-03-30 : 09:43:28
|
| Not unless you've been tracing your database for the last year or have a datetime stampe field on the tabl signifying last insert/update or something. SQL can give creation date but not last used....Terry-- Procrastinate now! |
 |
|
|
|
|
|
delete unused tables