dpdbadmin dropschema
The dpdbadmin dropschema command is used to undo the ODBC schema extension. It removes all the tables added using dpdbadmin addschema.
The database administrator account used must have permissions to drop tables.
Syntax
dpdbadmin dropschema –d dsn [OPTION]...
where dsn is the ODBC data source name.
Command-line options
| Option | Parameter | Description |
|---|---|---|
| ‑audit | Drop the auditing tables. By default, only the main tables used by OneSpan Authentication Server are dropped. | |
| ‑d, ‑dsn | dsn | Required. ODBC data source name (DSN), e.g. "IAS embedded database". |
| ‑h, ‑help | Show help and usage information. | |
| ‑l, ‑log | logfile | Write output to logfile. |
| ‑noserver | Do not drop the main tables used by OneSpan Authentication Server. This should only be used with ‑audit, when you only want to drop the auditing tables. | |
| ‑p, ‑password | dbpassword |
Optional. Password of the database administrator. This option can be omitted if the database administrator account has a blank password. |
| ‑q, ‑quiet | Quiet mode. Do not output commentary text. | |
| ‑u, ‑user | dbusername | Optional. User name of a database administrator (if required). |
| ‑v, ‑verbose | Print verbose output. Can be specified twice to be more verbose. | |
| ‑vdscontrol | tablename | The alternative name for the control table specified when creating the schema using dpdbadmin addschema. |
| ‑y, ‑assume‑yes | Run the command non-interactively and assume Yes as answer to all confirmation prompts. |
Exit codes
| Exit code | Description |
|---|---|
| 0 | The command completed successfully. |
| 1 | The command has been aborted by the user. |
| 2 | The command failed due to an unspecified error. |
| 3 | The specified parameters are invalid. |
| 4 | The command failed due to an error. |
| 5 | The database authentication failed. |
Examples
To drop a schema from the database using the data source name IAS embedded database and the user credentials digipass and digipassword type:
dpdbadmin dropschema –u digipass –p digipassword –d "IAS embedded database"