Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: SQL Server Objects > Programmability > Stored Procedures > About Stored Procedures

About Stored Procedures

A stored procedure is reusable code that is stored on the database server and can be invoked by other applications. Currently, Toad supports T-SQL stored procedures.

Tip: You can change how objects display in the Object Explorer. For example, you can create custom categories or move objects out of existing categories (such as Programmability and Security) in Tools | Options | Explorer | Objects.

Stored Procedure Details

You can display details about a procedure by selecting it in the Database Explorer or Object Explorer. The following table describes the details associated with each stored procedure:

Use this tab...	To display...
Parameters	Characteristics about the procedure such as position, name, data type, and length.
Dependencies	Dependent procedure objects and the objects that contain reference to the procedure.
Extended Properties	Extended properties you define to store additional metadata for this object.
Script	SQL statements for the selected object.