how to get a list of all tables in all database on a single server

• alpoor reddy

  SSC-Addicted

  Points: 435

  More actions

  February 9, 2007 at 10:01 am

  #175907

  how to get a list of all tables in all database on a single server

  I would appreciate your help

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  February 9, 2007 at 10:24 am

  #688909

  sp_msforeachdb 'SELECT ''?'' AS db_name, name as table_name from ?..sysobjects where xtype = ''U'' order by name asc'

  Try that...