DROP TRIGGER Statement mysql>  DROP TABLESPACE ts1; This example demonstrates dropping an undo tablespace. An undo tablespace must be in an  empty  state before it can be dropped. For more information, see Section 15.6.3.4, “Undo Tablespaces” . mysql>  DROP UNDO TABLESPACE  undo_003 ; This example shows how to drop an  NDB  tablespace  myts  having a data file named  mydata-1.dat after first creating the tablespace, and assumes the existence of a log file group named  mylg  (see Section 13.1.16, “CREATE LOGFILE GROUP Statement” ). You must remove all data files from the tablespace using  ALTER TABLESPACE , as shown here, before it can be dropped: DROP TRIGGER [IF EXISTS] [ schema_name .] trigger_name This statement drops a trigger. The schema (database) name is optional. If the schema is omitted, the trigger is dropped from the default schema.  DROP TRIGGER  requires the  TRIGGER  privilege for the table associated with the trigger. Use  IF EXISTS  to prevent an error from occurring for a trigger that does not exist. A  NOTE  is generated for a nonexistent trigger when using  IF EXISTS . See Section 13.7.7.42, “SHOW WARNINGS Statement” . Triggers for a table are also dropped if you drop the table. DROP VIEW  removes one or more views. You must have the  DROP  privilege for each view. If any views named in the argument list do not exist, the statement fails with an error indicating by name which nonexisting views it was unable to drop, and no changes are made. In MySQL 5.7 and earlier,  DROP VIEW  returns an error if any views named in the argument list do not exist, but also drops all views in the list that do exist. Due to the change in behavior in MySQL 8.0, a partially completed  DROP VIEW  operation on a MySQL 5.7 replication source server fails when replicated on a MySQL 8.0 replica. To avoid this failure scenario, use  IF EXISTS  syntax in  DROP VIEW  statements to prevent an error from occurring for views that do not exist. For more information, see Section 13.1.1, “Atomic Data Definition Statement Support” . 2616 Note 13.1.35 DROP VIEW Statement 13.1.34 DROP TRIGGER Statement NDB Example mysql>  CREATE TABLESPACE myts -> ADD DATAFILE ’mydata-1.dat’ -> USE LOGFILE GROUP mylg -> ENGINE=NDB; mysql>  ALTER TABLESPACE myts -> DROP DATAFILE ’mydata-1.dat’ -> ENGINE=NDB; mysql>  DROP TABLESPACE myts; DROP VIEW [IF EXISTS] view_name  [,  view_name ] ... [RESTRICT | CASCADE]