Teradata Package for Python Function Reference on VantageCloud Lake - db_drop_view - Teradata Package for Python - Look here for syntax, methods and examples for the functions included in the Teradata Package for Python.

Teradata® Package for Python Function Reference on VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Package for Python
Release Number
20.00.00.03
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-19
dita:id
TeradataPython_FxRef_Lake_2000
Product Category
Teradata Vantage
teradataml.dbutils.dbutils.db_drop_view = db_drop_view(view_name, schema_name=None)
DESCRIPTION:
    Drops the view from the given schema.
 
PARAMETERS:
    view_name:
        Required Argument
        Specifies view name to be dropped.
        Types: str
 
    schema_name:
        Optional Argument
        Specifies schema of the view to be dropped. If schema is not specified, function drops view from the current
        database.
        Default Value: None
        Types: str
 
RETURNS:
    True - if the operation is successful.
 
RAISES:
    TeradataMlException - If the view doesn't exist.
 
EXAMPLES:
    # Create a view
    >>> connection_object.execute("create view temporary_view as (select 1 as dummy_col1, 2 as dummy_col2);")
 
    # Drop view in current schema
    >>> db_drop_view(view_name = 'temporary_view')
 
    # Drop view from the given schema
    >>> db_drop_view(view_name = 'temporary_view', schema_name = 'alice')