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

sp_hidetext hides the source text for the specified compiled object.

WARNING! Before executing sp_hidetext, make sure you have a backup of the source text. The results of executing sp_hidetext are not reversible.
If you do not provide any parameters, sp_hidetext hides the source text for all compiled objects in the current database.

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.