DROP ODATA PRODUCER statement

Drops an OData Producer.

Syntax

DROP ODATA PRODUCER [ IF EXISTS ] name

Remarks

Removes the definition of the OData Producer and all of its options from the system tables. Use this statement only when you want to delete the configuration data of the OData Producer. If you want to temporarily disable the OData Producer, then execute the following statement:

ALTER ODATA PRODUCER name NOT ENABLED;

Use the IF EXISTS clause if you do not want an error returned when the DROP ODATA PRODUCER statement attempts to remove an OData Producer that does not exist.

Privileges

You must have the MANAGE ODATA system privilege.

Side effects

If the OData server is running, then the specified producer is shut down.

Example

To drop the OData Producer named prod, execute the following statement:

DROP ODATA PRODUCER prod;