There is already an object named in the database

Smart catch

use h5p;
drop table cached_assets;
create table cached_assets
(
    cached_id   int          not null,
    cached_type varchar(200) not null,
    path        varchar(200) not null,
    index cached_assets (cached_id, cached_type)
);

Still issue exists

Definitely, you are doinig any mistakes first check it carefully

In case if you use a database and try to delete then it gives an error so you needs to use any other database like a master, etc then

It's trying to drop definitely it's working.