Deleting OLE DB Table Functions - IBM Database Add-Ins for Visual Studio

Using the Server Explorer, you can delete an existing OLE DB table function from a DB2^® database.

Requirement: To delete an OLE DB table function, you must own the table function and have at least one of the following database privileges or authorities:

DELETE privilege
DROPIN privilege for the schema or all schemas
SYSADM or SYSCTRL authority

Your database administrator can provide you with the proper authority.

Prerequisite: If you created a DB2 table of the OLE DB data or a DB2 view for the table function, you must delete these objects before you delete the table function. An error occurs if you try to delete the table function while the table or the view for the table function exists in the DB2 database.

To delete an OLE DB table function:

In the Server Explorer under your data connection, right-click the OLE DB table function that you want to delete, and then select Delete on the shortcut menu.
Click Yes in the confirmation window.

The OLE DB table function is deleted from the database.

Deleting OLE DB Table Functions (DB2)

See Also