[code lang=“sql“]use mydb
\ngo
\nselect s.object_id, s.name, s.schema_id, s.type, s.type_desc, object_definition(s.object_id)
\nfrom sys.all_objects s
\nwhere type IN (‚P‘, ‚V‘, ‚FN‘, ‚TR‘, ‚IF‘, ‚TF‘, ‚U‘)
\nand is_ms_shipped = 0
\norder by s.type, s.name
\ngo[\/code]<\/p>\n
[code lang=“sql“]use mydb
\ngo
\nsp_helprotect
\ngo
\nsp_helprotect ‚dbo.myview‘
\ngo
\nsp_help ‚dbo.myview‘
\ngo
\nselect object_definition(OBJECT_ID(‚dbo.myview‘))
\ngo[\/code]<\/p>\n","protected":false},"excerpt":{"rendered":"
[code lang=“sql“]use mydb go select s.object_id, s.name, s.schema_id, s.type, s.type_desc, object_definition(s.object_id) from sys.all_objects s where type IN (‚P‘, ‚V‘, ‚FN‘, ‚TR‘, ‚IF‘, ‚TF‘, ‚U‘) and is_ms_shipped = 0 order by s.type, s.name go[\/code] [code lang=“sql“]use mydb go sp_helprotect go sp_helprotect ‚dbo.myview‘ go sp_help ‚dbo.myview‘ go select object_definition(OBJECT_ID(‚dbo.myview‘)) go[\/code]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1399","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"_links":{"self":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/1399","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/comments?post=1399"}],"version-history":[{"count":1,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/1399\/revisions"}],"predecessor-version":[{"id":1400,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/1399\/revisions\/1400"}],"wp:attachment":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/media?parent=1399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/categories?post=1399"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/tags?post=1399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}