All for Joomla All for Webmasters

SQL DELETE VIEW

Before knowing about what is SQL delete view, it is important to know –

What is SQL view?

A view is a result set of a stored query on the data.

The SQL view is a table which does not physically exist. It is only a virtual table.

SQL VIEW can be created by a SQL query by joining one or more table.

Syntax for SQL create view –

  1. CREATE VIEW view_name AS
  2. SELECT columns
  3. FROM tables
  4. WHERE conditions;

If you want to delete a SQL view, It is done by SQL DROP command you should use the following syntax:

SQL DROP VIEW syntax:

  1. DROP VIEW view_name

Why use the SQL DROP VIEW statement?

When a view no longer useful you may drop the view permanently. Also if a view needs change within it, it would be dropped and then created again with changes in appropriate places.

PinIt
submit to reddit

Leave a Reply

Top