IBM Database Add-Ins for Visual Studio  

Deleting Procedures, Functions, or Objects from an IBM Database

Using the Server Explorer, you can delete an existing procedure, function, or object (that is, a table or a view) from an IBM database.

Requirement: To delete a procedure, function, or object from a database, you must own the procedure, function, or object and have at least one of the following database privileges or authorities:

For a DB2 database
  • DELETE privilege
  • DROPIN privilege for the schema or all schemas
  • SYSADM or SYSCTRL authority
For an IDS database
  • DELETE privilege
  • informix user ID

Your database administrator can provide you with the proper authority.

For a DB2 database If you delete a table, the triggers that are associated with the table are not deleted from the database; they are marked inoperative. You can either delete triggers that are associated with the table, or you can re-create triggers after they become inoperative. If you want to delete a trigger, you must delete it before you delete the table.

For an IDS database Deleting overloaded procedures that are based on data type produces undefined results.

To delete a procedure, function, or object from an IBM database:

  1. In the Server Explorer under your data connection, right-click the procedure, function, or object, and then click Delete.
  2. Click Yes in the confirmation window.

The procedure, function, or object is deleted from the database.

See Also

Managing Procedures, Functions, and Objects | Deleting Triggers That Are Associated with Tables | Re-Creating Inoperative Triggers



.NET Development Forum   DB2 FAQs   IDS FAQs

© Copyright IBM Corporation 2002, 2019. All Rights Reserved.