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

The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

  • 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