×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

DB objects search

0
0
 
0
Language: SQL
Posted by: Károly Szalai
Added: Feb 12, 2021 8:32 AM
Views: 4743
Tags: no tags
  1. SELECT DISTINCT o.name AS Object_Name, o.type_desc
  2. FROM sys.sql_modules m
  3.          INNER JOIN sys.objects o ON m.object_id = o.object_id
  4. WHERE m.definition LIKE '%misz_munkalap_xmlrogzites%' ESCAPE '\'
  5.  

Write a comment

To post comments, please log in or register.