{"id":67,"date":"2013-03-15T14:27:00","date_gmt":"2013-03-15T19:27:00","guid":{"rendered":"https:\/\/www.chrystalsander.com\/blog\/?p=67"},"modified":"2023-07-26T12:36:05","modified_gmt":"2023-07-26T17:36:05","slug":"sql-server-query-definition-of-an-object","status":"publish","type":"post","link":"https:\/\/www.chrystalsander.com\/blog\/?p=67","title":{"rendered":"SQL Server : Query Definition of an Object"},"content":{"rendered":"<div>\n<div>\n<p style='text-autospace:none'><span style='font-size:10.0pt;font-family:\"Courier New\";color:green'>&#8212; Another way to query the definition of an object:<o:p><\/o:p><\/span><\/p>\n<p style='text-autospace:none'><span style='font-size:10.0pt;font-family:\"Courier New\";color:blue'>SELECT<\/span><span style='font-size:10.0pt;font-family:\"Courier New\"'> <span style='color:fuchsia'>OBJECT_NAME<\/span><span style='color:gray'>(<\/span><span style='color:fuchsia'>object_id<\/span><span style='color:gray'>),<\/span> <span style='color:gray'>*<o:p><\/o:p><\/span><\/span><\/p>\n<p style='text-autospace:none'><span style='font-size:10.0pt;font-family:\"Courier New\";color:blue'>FROM<\/span><span style='font-size:10.0pt;font-family:\"Courier New\"'> <span style='color:green'>sys<\/span><span style='color:gray'>.<\/span><span style='color:green'>sql_modules<o:p><\/o:p><\/span><\/span><\/p>\n<p><span style='font-size:10.0pt;font-family:\"Courier New\";color:blue'>WHERE<\/span><span style='font-size:10.0pt;font-family:\"Courier New\"'> <span style='color:fuchsia'>LOWER<\/span><span style='color:gray'>(<\/span><span style='color:blue'>DEFINITION<\/span><span style='color:gray'>)<\/span> <span style='color:gray'>LIKE<\/span> <span style='color:red'>&#8216;%tbl%&#8217;<\/span><\/span><o:p><\/o:p><\/p>\n<\/div>\n<p><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&#8212; Another way to query the definition of an object: SELECT OBJECT_NAME(object_id), * FROM sys.sql_modules WHERE LOWER(DEFINITION) LIKE &#8216;%tbl%&#8217;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[45,27],"tags":[58,50],"_links":{"self":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/67"}],"collection":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=67"}],"version-history":[{"count":1,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/67\/revisions"}],"predecessor-version":[{"id":179,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/67\/revisions\/179"}],"wp:attachment":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}