Skip to content

Coder Tutorial

Menu
  • Home
  • HTML
  • CSS
  • PHP
  • SQL
  • MySQL
  • JS
  • PL/SQL
  • Python
  • Java
  • Oracle
Home
MySQL
MySQL Drop view

MySQL Drop view

MySQL Drop view

To DROP a MySQL view uses keyword drop view syntax.

MySQL Drop view syntax

DROP VIEW view_name;

Drop view example

DROP VIEW test_view;

Output

view TEST_VIEW dropped.

Tutorials

  • MySQL Tutorial
  • Database
  • Data Types
  • Insert
  • Update
  • Delete
  • Select
  • Clauses
  • Where
  • AND
  • OR
  • IN
  • Between
  • Order By
  • Limit
  • Flow Control Statements
  • CASE
  • IF
  • Iterate
  • Leave
  • Loop
  • Repeat
  • Return
  • While
  • Functions and Operators
  • Table
  • View
  • Temporary Table
  • Triggers
  • Procedure
  • Function
  • Indexes
  • Transactions
  • Create trigger
  • Create table
  • Drop table
  • Add column
  • Drop column
  • Rename column
  • Add primary key
  • Add constraint foreign key
  • Drop foreign key
  • Add index
  • Drop index

Recent Posts

  • PostgreSQL ERROR: cannot begin/end transactions in PL/pgSQL
  • PostgreSQL Column must appear in the GROUP BY clause
  • PostgreSQL Column specified more than once
  • PostgreSQL Create database, Alter database examples
  • PostgreSQL Create schema syntax, Alter schema
Coder Tutorial Copyright © 2023. | Privacy Policy
Back to Top ↑