How to get list of database objects for finding specific tables used in storedproceure or functions

select distinct B.name from syscomments Ainner join sys.objects B on A.id =B.object_id where A.text like '%tablename%'

Comments

Popular posts from this blog

List of special Characters in HTML

Get Random alphanumeric number with specific length using SQL Server