March 17, 2003 at 12:23 am
I've got a database on a server with a lot of unused or infrequently used tables. A LOT of tables that were added over the years. In order to do some housekeeping I need to find which tables in these database(s) are not being used, or haven't been say used/accessed for the past month(s) so I can DROP them. Any easy way to do this? Any stats on this somewhere in a system table?
Regards
Phillip
March 17, 2003 at 10:07 am
No. You could create triggers or a trace to start finding wich tables are acceded, or you could backup the tables,drop the tables and see if anyone complains...
March 17, 2003 at 10:48 am
How about removing ALL of the rights to those tables? Then if they complain all he has to do is readd the rights. I would make sure to document the previous rights in case you have to readd them. Either solution works for me.
Tim C.
//Will write code for food
Tim C //Will code for food
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply