Teradata Package for Python Function Reference - 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

Product
Teradata Package for Python
Release Number
17.00
Published
November 2021
Language
English (United States)
Last Update
2021-11-19
lifecycle
previous
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')