sp_hidetext

Description

Hides the source text for the specified compiled object.

Syntax

sp_hidetext [objname [, tabname [, username]]]

Parameters

objname

specifies the compiled object for which to hide the source text.

tabname

specifies the name of the table or view for which to hide the source text.

username

specifies the name of the user who owns the compiled object for which to hide the source text.

Examples

Example 1

Hides the source text of all compiled objects in the current database:

sp_hidetext

Example 2

Hides the source text of the user-defined stored procedure, sp_sort_table, that is owned by Mary:

sp_hidetext @objname = "sp_sort_table", @username = "Mary"

Example 3

Hides the source text of the stored procedure pr_phone_list:

sp_hidetext "pr_phone_list"

Example 4

Hides the source text of all check constraints, defaults, and triggers defined on the table my_tab:

sp_hidetext @tabname = "my_tab"

Example 5

Hides the source text of the view my_vu and all check constraints, defaults, and triggers defined on the table my_tab:

sp_hidetext "my_vu", "my_tab"

Example 6

Hides the source text of all compiled objects that are owned by Tom:

sp_hidetext @username = "Tom"

Usage

Permissions

Any user can use sp_hidetext to hide the source text of his or her own compiled objects. Only a Database Owner or a System Administrator can hide the source text of compiled objects that are owned by another user or use sp_hidetext with no parameters.

See also

Documents See the Transact-SQL User’s Guide for more information about hiding source text.

System procedures sp_checksource