drop view if exists then create code example Example: sql drop view if exists DROP VIEW IF EXISTS yourview;