Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/developer-guide/python-connector/../../sql-reference/sql/drop-view below:

Website Navigation

• Reference
• SQL command reference
• Tables, views, & sequences

DROP VIEW | Snowflake Documentation

Removes the specified view from the current/specified schema.

See also:

CREATE VIEW , ALTER VIEW , SHOW VIEWS , DESCRIBE VIEW

DROP VIEW [ IF EXISTS ] <name>

Copy

name

Specifies the identifier for the view to drop. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

If the view identifier is not fully-qualified (in the form of db_name.schema_name.table_name or schema_name.table_name), the command looks for the view in the current schema for the session.

• Dropped views can’t be recovered; they must be recreated.

• When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.

------------------------------+
           status             |
------------------------------+
 MYVIEW successfully dropped. |
------------------------------+

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4