Table Inventory used and not in used

• Ayie

  SSC Eights!

  Points: 828

  More actions

  August 7, 2008 at 7:12 pm

  #190740

  Hello again everybody DBA's,

  my question is

  1. How would I know that the table inside the database is already up to date or used by the program.

  2. How would I know that the table inside is not in used or not updated, i mean is not totally used by the application, because I want to delete the table, to clean up the database.

  Anyone can give me the Scripts for this situation?

  Thank you

  Ayie

• abmore

  Hall of Fame

  Points: 3628

  More actions

  August 8, 2008 at 12:47 am

  #854934

  You can not detect that which table is used by Application, for that you have to do manual work there is no such tool.

  About database you can check that whether the table is reference anywhere or not checking the dependents on that table.