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 |
|
addictmobile
Starting Member
1 Post |
 Posted - 2008-04-24 : 19:24:44
|
| We have 350 tables in our database, I want to drop/delete those table(s) that are inactive. Is there a way to check which tables are not active, so I could drop/delete that table(s). |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-24 : 19:34:34
|
| You'd have to trace the information via SQL Profiler, add triggers to all of your tables, or check the last row inserted if you've got a datetime column with a default of GETDATE().Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
inactive tables