在IDS中创建和删除存储过程。
如果您打算删除存储过程并且不会重新创建它，那么这个操作就有用了。
This is useful if you plan to drop the stored procedure and not create it again.
要从Serverexplorer树中删除存储过程，右键单击树中相应的存储过程节点，然后选择Delete菜单选项。
To delete stored procedures from the server explorer tree, right-click on the appropriate stored procedure node in the tree, and select the delete menu option.
可以使用非模态的设计程序创建和删除数据库对象，例如表、视图、存储过程和函数。
You can create and delete database objects such as tables, view, stored procedures, and functions using non-modal designers.
该插件还将创建存储过程，用于添加、删除和修改用户、组以及组成员信息。
The plug-in also creates stored procedures, which are used to add, remove, and modify user, group, and group membership information.
要纠正这个问题，可以从上面的代码中删除第 23行，重新编译存储过程，并且将新的类文件转移到sqllib\function文件夹。
To fix the problem, remove line 23 from the above code, recompile the stored procedure, and move the new class file to the sqllib\function folder.
由于过程被删除并重新创建，所以您可以毫无限制地更改在创建过程中指定的所有存储过程选项。
Since the procedure is dropped and re-created, you can alter all the stored procedure options specified during the creation without any restrictions.
目前，IBM工具通过始终删除现有过程并使用新定义重新创建新过程来处理存储过程的更改。
Currently, the IBM tooling handles altering of a stored procedure by always dropping the existing procedure and then re-creating the new procedure using the new definition.
要重新绑定存储过程的包，我们需要先删除它，然后再重新创建绑定新REOPT级别的存储过程，或者为这个特定的SQL存储过程重新绑定一个包。
To rebind the package for a stored procedure, drop and recreate it with new REOPT level, or rebind the package for this specific SQL stored procedure.
存储过程中的第一个语句是DELETE，它删除本地目标表SALES 中现有的行。
The first statement within the stored procedure is a DELETE to remove the existing rows in the local destination table SALES.
试图删除并且重新创建存储过程，但是在再次调用sqlj . install_jar之前没有删除jar文件。
When you attempt to drop and recreate the stored procedure, but did not remove the jar file before calling sqlj.install_jar again.
DB 2提供了一个由系统定义的存储过程，称为SYSINSTALLOBJECTS，它可以创建或删除OPT _ profile表。
DB2 provides a system-defined stored procedure called SYSINSTALLOBJECTS that can create or drop the OPT_PROFILE table.
这是更好地创建所需的任何操作在一个数据库中的表的存储过程(例如创建和读取此表，更新和删除只有一个，……)？
Is it better to create stored procedures for any required operations on a table in the database (e. g. create and read on this table, update and delete only on another one,...)?
当不再需要某存储过程或用户定义的函数时，可以将其从数据库中删除。
When you no longer need a stored procedure or user-defined function, you can delete it from the database.
发送SQL指令和结果表明：你可以创建和删除数据库的SQL查询，发送，创建和执行存储过程和函数…假设你有正确的权限。
Send SQL instructions and show the results: you can create and drop databases, send SQL queries, create and execute stored procedures and functions... all assuming you have the right privileges.
当创建表以后，在建立索引，视图等。当删除表的时候，所有依赖于该表的对象都变的无效了，包括视图，包，包体，函数和存储过程。
Whenever you create a table, index, and view, and then drop the table, all objects dependent on that table are invalidated, including views, packages, package bodies, functions, and procedures.
ALTERROUTINE权限需要去更改或删除存储的例程(存储过程和函数)。
The alter routine privilege is needed to alter or drop stored routines (procedures and functions).
ALTERROUTINE权限需要去更改或删除存储的例程(存储过程和函数)。
The alter routine privilege is needed to alter or drop stored routines (procedures and functions).
应用推荐