Learn more about Toad for SQL Server
at Dell Software

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

Toad for SQL Server 6.6

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