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

Teradata® Package for Python User Guide

Product
Teradata Package for Python
Release Number
17.00
Release Date
November 2021
Content Type
User Guide
Publication ID
B700-4006-070K
Language
English (United States)

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