The DROP DB_DISCOVERY TYPE
syntax is used to drop database discovery type for specified database
DropDatabaseDiscoveryType ::=
'DROP' 'DB_DISCOVERY' 'TYPE' ifExists? dbDiscoveryTypeName (',' dbDiscoveryTypeName)* ('FROM' databaseName)?
ifExists ::=
'IF' 'EXISTS'
dbDiscoveryTypeName ::=
identifier
databaseName ::=
identifier
databaseName
is not specified, the default is the currently used DATABASE
. If DATABASE
is not used, No database selected will be prompted;dbDiscoveryTypeName
obtain through SHOW DB_DISCOVERY TYPE syntax query;ifExists
clause is used for avoid Database discovery type not exists
error.DROP DB_DISCOVERY TYPE group_0_mysql_mgr, group_1_mysql_mgr FROM discovery_db;
DROP DB_DISCOVERY TYPE group_0_mysql_mgr;
ifExists
clauseDROP DB_DISCOVERY TYPE IF EXISTS group_0_mysql_mgr;
DROP
, DB_DISCOVERY
, TYPE
, FROM