madentdrop utility
The madentdrop utility drops database tables and indexes of an entity type (enttype).
Before you run a utility, make sure that you have set the necessary operational server environment variables. For information about the variables, see the operational server environment variables topic.
Option | Type | Description | Default |
---|---|---|---|
-entType | entType | Specifies the name of the entity on which to run the operation | NONE |
-rptPfx | List the entity name prefixes | NONE | |
-noExec | Show SQL statements only; no execution is processed | NONE | |
-verbose | Show progress information | NONE | |
-help | List help information | NONE | |
-version | List version number | NONE | |
-rootDir | MAD_ROOTDIR; location of MDM software. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | ||
-homeDir | MAD_HOMEDIR; location operational server instance. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | ||
-connStr | MAD_CONNSTR; ODBC connection string. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | ||
-dbType | MAD_DBTYPE; native database name. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | ||
-dbServer | MAD_DBSERVER; native database server. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional if not using native | |
-dbName | MAD_DBNAME; native database name. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional if not using native | |
-dbUser | MAD_DBUSER; native database user ID.The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional if not using native | |
-dbPass | MAD_DBPASS; native database password. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional if not using native | |
-encoding | MAD_ENCODING; encoding of .unl files; options are: UTF8, UTF16, or LATIN1. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | LATIN1 |