The Wiert Corner – irregular stream of stuff

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

  • My badges

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

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

    Join 2,318 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 [WayBack] Find 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

This entry was posted on 2020/10/13 at 12:00 and is filed under Database Development, Development, SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

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

Gravatar
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 )

Cancel

Connecting to %s

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

«
»
 
<span>%d</span> bloggers like this: