db_drop_view() | Database Utilities | Teradata Python Package - db_drop_view() - Teradata Package for Python

Teradata® Package for Python User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for Python
Release Number
20.00
Published
March 2024
Language
English (United States)
Last Update
2024-04-09
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
dita:id
rkb1531260709148
Product Category
Teradata Vantage

Use the db_drop_view() function to drop a view from a given schema. Returns True if the operation is successful.

Required arguments:
  • view_name specifies the view name to be dropped.
Optional arguments:
  • schema_name specifies the database of the view to be dropped. If a database is not specified, the function drops view from the current database.

Example Prerequisites

Create a temporary view:
>>> connection_object.execute("create view temporary_view as (select 1 as dummy_col1, 2 as dummy_col2);")

Example 1: Drop a view "temporary_view" from current database

>>> db_drop_view(view_name = 'temporary_view')
True

Example 2: Drop a view "temporary_view" from schema "alice"

>>> db_drop_view(view_name = 'temporary_view', schema_name = 'alice')
True