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. This task can't be performed using Transact-SQL statements. Right-click the function you wish to rename and select Rename. Select the plus sign next to the folder that contains the function you wish to rename: Select the plus sign next to the Programmability folder. In Object Explorer, select the plus sign next to the database that contains the function you wish to rename and then 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. Instead, drop and re-create the stored procedure with its new name.Ĭhanging the name or definition of a user-defined function can cause dependent objects to fail when the objects aren't updated to reflect the changes that have been made to the function.ĭropping the function requires either ALTER permission on the schema to which the function belongs, or CONTROL permission on the function.
#TABLEPLUS VIEW SQL PRINT HOW TO#
Therefore, we recommend that you don't rename this object type. How to connect Open TablePlus app, from the welcome screen, click Create a New Connection at the bottom, or right-click on the connection view and choose New. Renaming a user-defined function won't change the name of the corresponding object name in the definition column of the sys.sql_modules catalog view. Limitations and restrictionsįunction names must comply with the rules for identifiers. You can only rename user-defined functions in SQL Server by using SQL Server Management Studio. TablePlus supports most of the popular databases such as MySQL, Postgres, SQL Server, SQLite, Microsoft SQL Server, Redis, Redshift, Oracle, and many more. Applies to: SQL Server Azure SQL Database TablePlus is a modern, native app with a clean user interface that allows developers to simultaneously manage databases in a very fast and secure way.
0 kommentar(er)
