Search of table names

sql, sql-server, sql-server-2008-r2

Solution

I'm using this and works fine

SELECT * FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_NAME LIKE '%%'

Problem

I use the following to search for strings within the stored procedures of a specific database: ``` USE DBname SELECT Name FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%xxx%' ``` Is it easy to amend the above so that it searches Table names in a specific db "DBname" ?

Original source

Related problems