Drop view which does not exist

Question

I am unable to create a view. It throws an error that that table already exists, but if I try to drop it, it says unknown table. I checked out this question but it didnt help much.

drop view if exists foo;
create view foo ... ;
# Table foo already exists
drop table / DROP TABLE IF EXISTS foo;
# unknown table foo

Flush table/repair table didnt solve either. Any ideas ?

Title is misleading, Drop table is not equal to Drop View.... — Ron van der Heijden, Jan 21 '13 at 14:39
@Bondye I am trying to create a view, but it throws error for table already exists with same name, but dropping it throws unknown table name error. — GoodSp33d, Jan 21 '13 at 14:58
`DROP VIEW foo;` and `CREATE VIEW foo AS SELECT * FROM bar;` — Ron van der Heijden, Jan 21 '13 at 15:12

score 34 · Answer 1 · answered Jan 21 '13 at 20:53

34

use the following syntax to replace the view:

CREATE OR REPLACE VIEW `my_view` AS SELECT ...

answered Jan 21 '13 at 20:53

MOCKBA

1,680
11
19

nice! I thought this was a oracle thing, but then I tried. Sweet – ant Dec 19 '16 at 13:58

Drop view which does not exist

1 Answers1