By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

Any command for renaming a Stored Procedure?

P: 9
Hi
I am working on DB2 8.2 version and I have only rights to access through Command Line Processor. I want to change the name of the one of the Stored Procedure through CLP is there any command for this( Re naming storedprocedure).
Feb 20 '07 #1
Share this Question
Share on Google+
3 Replies


10K+
P: 13,264
Hi
I am working on DB2 8.2 version and I have only rights to access through Command Line Processor. I want to change the name of the one of the Stored Procedure through CLP is there any command for this( Re naming storedprocedure).
Have a look at sp_rename.
Feb 20 '07 #2

P: 9
Have a look at sp_rename.
HI GURU
Can you tell me the syntax of this command
Feb 20 '07 #3

P: 2
Syntax
sp_rename [@objname =] 'object_name',
[@newname =] 'new_name'
[, [@objtype =] 'object_type']

Arguments
[@objname =] 'object_name'
Is the current name of the user object (table, view, column, stored procedure, trigger, default, database, object, or rule) or data type. If the object to be renamed is a column in a table, object_name must be in the form table.column. If the object to be renamed is an index, object_name must be in the form table.index. object_name is nvarchar(776), with no default.
[@newname =] 'new_name'
Is the new name for the specified object. new_name must be a one-part name and must follow the rules for identifiers. newname is sysname, with no default.
[@objtype =] 'object_type'
Is the type of object being renamed. object_type is varchar(13), with a default of NULL, and can be one of these values.
Feb 20 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.