Dropping ODBC Schema Extensions

You can use the dpdbadmin dropschema command to revert the ODBC schema extension, thereby removing all the tables added using dpdbadmin addschema.

It may be necessary to go through an approval process in your company before performing this task. You may also need to have a database administrator perform the task for you.

Before you use the command, prepare the following:

• Database name. You need the data source name of the database (as registered with Windows or Linux as an ODBC data source). This DSN must be registered on the computer from which the command line utility will be run.
• Database administrator account. To successfully modify the database structure, you need the username and password of a database administrator account that is able to make changes to the database structure. You must pass these credentials to the utility in the parameters of the command.

In this case, the Database Administrator Account must have permissions to drop tables.

To drop the ODBC schema extension use the following command:

dpdbadmin dropschema –u dbusername –p dbpassword -d dsn

where:

• dbusername is the user name of the database administrator account.
• dbpassword is the corresponding password of dbusername.
• dsn is the ODBC data source name.

For more information about dpdbadmin dropschema, see dpdbadmin dropschema.