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

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


Popular posts from this blog

List of special Characters in HTML

Get Random alphanumeric number with specific length using SQL Server