Pages

Sunday, September 8, 2013

SQL SERVER – List All the Tables for All Databases Using System Tables | Journey to SQL Authority with Pinal Dave

Today we will go over very simple script which will list all the tables for all the database. sp_msforeachdb 'select "?" AS db, * from [?].sys.tables' Update: Based on comments received below I have updated this article. Thank you to all the readers. This is good example where something small like this have good participation from readers. Reference : Pinal Dave… Continue Reading...

Source: SQL SERVER – List All the Tables for All Databases Using System Tables | Journey to SQL Authority with Pinal Dave