The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

    • @iRepeltje Slim plan. En dan nog wat eten voor hem? (als soort stok achter de deur) 9 minutes ago
    • RT @nrc: De AVG wist cookies eronder te krijgen, maar nu storten adverteerders zich op alternatieven die de privacy nog meer bedreigen. Hoe… 23 minutes ago
    • RT @gathara: #BREAKING Dutch police have brutally crushed protests demanding fundamental freedoms, which officials see as embarrassing for… 24 minutes ago
    • RT @Carend_2020: Opnieuw verzorgen we de Webinar: "Interculturele en existentiële zorg bij corona!" Speciaal voor artsen, verpleegkundigen… 26 minutes ago
    • @EinsteinBarbie @bpschut Die heeft me tijden geleden al een keer geblocked. Vast omdat ik iets van je ge-retweet heb (: 27 minutes ago
  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,232 other followers

Find a Table on a SQL Server across all Databases – TechNet Articles – United States (English) – TechNet Wiki

Posted by jpluimers on 2020/10/13

Neither solution on [WayBackFind a Table on a SQL Server across all Databases – TechNet Articles – United States (English) – TechNet Wiki is nice, but the most readable (though undocumented) works:

sp_MSforeachdb'SELECT "?" AS DB, * FROM [?].sys.tables WHERE name like ''%your_table_name%'''

Similar solutions at:

–jeroen

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

 
%d bloggers like this: