4D v16

DROP VIEW

Home

 
4D v16
DROP VIEW

DROP VIEW  


 

 

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

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".



Siehe auch 

CREATE VIEW

 
EIGENSCHAFTEN 

Produkt: 4D
Thema: SQL Commands

 
GESCHICHTE 

 
ARTIKELVERWENDUNG

4D - SQL Reference ( 4D v16)