Teradata Package for Python Function Reference - 17.00 - db_drop_view - Teradata Package for Python

Teradata® Package for Python Function Reference

Product
Teradata Package for Python
Release Number
17.00
Release Date
April 2021
Content Type
Programming Reference
Publication ID
B700-4008-070K
Language
English (United States)
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')