How to find out the orphan tables in the database?

• sanjeev_krs2004

  Default port

  Points: 1462

  More actions

  February 6, 2009 at 2:44 am

  #130605

  Hello team,

  I run few analysis on the tables which in turn creates some more tables in the same database. After reviewing the new tables and generating the reports, I usually delete the tables through the application (custom-application).

  What sometime I face that all of the tables are not deleted of a specific analysis. My question to you all is - Is there any way / script that I can run on the database and find out if there are any orphan tables in the database.

  I have a specific naming convention while naming the tables and there are 15 tables.

  For example, GV_00001_A

  GV_00002_A

  GV_00003_A

  if any of the table is not deleted, how I can find the table?

  Thanks in advance.

  Sanjeev.

• DBA in Unit 7

  SSCarpal Tunnel

  Points: 4059

  More actions

  February 6, 2009 at 7:11 am

  #939481

  select * FROM sys.objects

  where type ='U' and [name] like 'GV_%_A'

  This will give you the table information that is with your naming convention.