Rename User-defined Functions

  • Article

You can rename user-defined functions in SQL Server 2012 by using SQL Server Management Studio or Transact-SQL.

In This Topic

  • Before you begin:

    Limitations and Restrictions

    Security

  • To rename user-defined functions, using:

    SQL Server Management Studio

    Transact-SQL

Before You Begin

Limitations and Restrictions

  • Function names must comply with the rules for identifiers.

  • Renaming a user-defined function will not change the name of the corresponding object name in the definition column of the sys.sql_modules catalog view. Therefore, we recommend that you do not rename this object type. Instead, drop and re-create the stored procedure with its new name.

  • Changing the name or definition of a user-defined function can cause dependent objects to fail when the objects are not updated to reflect the changes that have been made to the function.

Security

Permissions

To drop the function, requires either ALTER permission on the schema to which the function belongs or CONTROL permission on the function. To re-create the function, requires CREATE FUNCTION permission in the database and ALTER permission on the schema in which the function is being created.

Arrow icon used with Back to Top link [Top]

Using SQL Server Management Studio

To rename user-defined functions

  1. In Object Explorer, click the plus sign next to the database that contains the function you wish to rename and then

  2. Click the plus sign next to the Programmability folder.

  3. Click the plus sign next to the folder that contains the function you wish to rename:

    • Table-valued Function

    • Scalar-valued Function

    • Aggregate Function

  4. Right-click the function you wish to rename and select Rename.

  5. Enter the function’s new name.

Arrow icon used with Back to Top link [Top]

Using Transact-SQL

To rename user-defined functions

This task cannot be performed using Transact-SQL statements. To rename a user-defined function using Transact-SQL, you must first delete the existing function and then re-create it with the new name. Ensure that all code and applications that used the function’s old name now use the new name.

For more information, see CREATE FUNCTION (Transact-SQL) and DROP FUNCTION (Transact-SQL).

Arrow icon used with Back to Top link [Top]

See Also

Reference

sys.sql_expression_dependencies (Transact-SQL)

Concepts

View User-defined Functions