Remove From My Forums

Search table name in Server

Question

0

Sign in to vote

Hi All,

I am new to SQL Server.

I have a table name but I don't know where this particular table exists.

Could you please help me by giving the query to search entire server.

Note:- As I have to search 4 servers, each server have so many databases.

I can't search database level.

Kindly let me know the query which search entire server (all databases in server).

Thanks in advance,

Sughesh.

Tuesday, June 25, 2013 6:42 AM

Reply

|

Quote

Answers

0

Sign in to vote
Hello Sughesh,

You could use the undocumented & unsupported system procedure "sp_MSforeachdb" to go through all databases to execute a statement to search for the table, like:

EXEC sp_MSforeachdb N'SELECT [?] AS DbName, name AS TableName FROM [?].sys.tables WHERE name = ''MyTableName'''

Olaf Helper
Blog Xing
- Proposed as answer by Mike YinMicrosoft contingent staff, Moderator Thursday, June 27, 2013 7:05 AM
- Marked as answer by Mike YinMicrosoft contingent staff, Moderator Monday, July 08, 2013 1:23 PM
Tuesday, June 25, 2013 6:53 AM

Reply

|

Quote