CODEWITHSUNDEEP
sqlsql-serversysobjects
NonProgrammer
NonProgrammer

Reputation: 1387

Need to identify a table in all objects in database

I need to identify a table that is mentioned anywhere in database (in stored proc, views, and, etc.). I tried to find a query online, but couldn't find it. Any help would be great!

Upvotes: 2

Views: 193

Answers (2)

user2680334
user2680334

Reputation:

I often use this snippet when I'm looking for dependencies. In this case, you would replace the text with what you're searching (assuming you're on MS SQL Server):

USE [DBNAME]

SELECT OBJECT_NAME(id)
FROM syscomments
WHERE [text] LIKE '%enter_search_here%'
GROUP BY OBJECT_NAME(id)

You can also look for specific object types by adding a check for object property:

    WHERE OBJECTPROPERTY(id, 'IsTable') = 1

Here is a LIST of useful object properties!

Upvotes: 2

BI Dude
BI Dude

Reputation: 2016

I use the free SQL Search plugin for MS Management Studio for things like that: http://www.red-gate.com/products/sql-development/sql-search/

Upvotes: 3

Related Questions