Stored Procedure Properties
Stored procedures are a precompiled collection of SQL statements and optional control-of-flow statements stored under a name and processed as a unit.
Note
The properties in this topic are ordered by category rather than alphabet.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.
Identity Category
Expands to show the Name property.Name
Shows the name of the selected stored procedure.Database
Shows the database to which the stored procedure belongs. (Applies only to OLE DB.)Schema
Shows the default schema of the stored procedure belongs. (Applies only to OLE DB.)Owner
Shows the owner of the procedure. (Applies only to Oracle.)Misc Category
Expands to show the remaining properties.Type
Shows the type of stored procedure. (Applies only to OLE DB.)Assembly Name
Shows the name of the assembly to which the stored procedure belongs. (Applies only to Microsoft SQL Server.)Is Encrypted
Shows whether the stored procedure was created with an optional encryption parameter. (Applies only to Microsoft SQL Server.)