C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

How to delete or change a stored procedure?

Posted Date: 23 Sep 2008 Resource Type: Articles Category: Databases

Posted By: Shashi Member Level: Gold
Rating:

Points: 5

How to delete or change a stored procedure?

You use DROP PROC statement to delete one or more stored procedures from database. To redefine the stored procedure you use ALTER PROC.

The syntax of the DROP PROC statement
DROP {PROC|PROCEDURE} Procedure_name [, …]

The syntax of the ALTER PROC statement
ALTER {PROC|PROCEDURE} Procedure_name
[Parameter_declaration]
[WITH {RECOMPILE|ENCRYPTION|RECOMPILE, ENCRYPTION}]
AS sql_statements

When you delete a procedure any security permission that are assigned to the procedure are also deleted. In that case you will want to use the ALTER PROC statement to modify the procedure and preserve permissions.

In this section I will take you to the types of stored procedures with some examples.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.