4D v16

DROP VIEW

Home

4D SQL Reference
- SQL Commands
- - SQL Commands
  - SELECT
  - INSERT
  - UPDATE
  - DELETE
  - CREATE DATABASE
  - USE DATABASE
  - ALTER DATABASE
  - CREATE TABLE
  - ALTER TABLE
  - DROP TABLE
  - CREATE INDEX
  - DROP INDEX
  - LOCK TABLE
  - UNLOCK TABLE
  - EXECUTE IMMEDIATE
  - CREATE SCHEMA
  - ALTER SCHEMA
  - DROP SCHEMA
  - CREATE VIEW
  - DROP VIEW
  - GRANT
  - REVOKE
  - REPLICATE
  - SYNCHRONIZE

Home

4D v16

4D SQL Reference

SQL Commands

DROP VIEW



	DROP VIEW [IF EXISTS] [schema_name.]view_name[;]

Description

The DROP VIEW command deletes the view named view_name from the database.

When the IF EXISTS constraint is passed, the command does nothing and no error is generated if the view_name view does not exist in the database.

schema_name is a standard sql_name and you can use it to designate the name of the schema that will contain the view. If you do not pass schema_name or if you pass the name of a schema that does not exist, the view is automatically considered to belong to the default schema, which is entitled "DEFAULT_SCHEMA".