[dba-VB] SQL Tables No Longer Used

paul.hartland at fsmail.net paul.hartland at fsmail.net
Tue Jun 27 04:48:56 CDT 2006


To all,
I have cross posted this just in case anyone else knows of anything, I don't know if this sort of software will be available...I have a SQL Database with a VB6 front-end that the company has decided it's time we totally re-design, now this database has been passed down twice so there are tables in it etc that are no longer used.  Is there a piece of software that can run through a SQL database and/or VB6 code that will tell me which tables/queries/views/store procedures are no longer used.  If not does anyone have a good strategy plan if they have done this before, this is a big database and I can't see a simple solution to totally re-designing it to also incorporate the existing data.
Thanks in advance for any help on this .

Paul Hartland


More information about the dba-VB mailing list