Stored Procedure Properties

  • Article

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.)

See Also

Other Resources

Properties in Visual Database Tools