Search for a Table in all databases

Total article views: 786 | Views in the last 30 days: 33

Usage of this script:

If the exact table name is known then specify the table name to the stored procedure else include the wild cards

EXEC FindTable 'Employee'
EXEC FindTable '%Employee%'

Total article views: 786 | Views in the last 30 days: 33

Your response

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Email: Password: Remember me: Forgotten your password?

Email: Password:

Confirm:

Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

Steve Jones
Editor, SQLServerCentral.com