Teradata Package for Python Function Reference - 17.00 - db_drop_view - Teradata Package for Python
Teradata® Package for Python Function Reference
- Teradata Package for Python
- Release Number
- November 2021
- English (United States)
- Last Update
- teradataml.dbutils.dbutils.db_drop_view = db_drop_view(view_name, schema_name=None)
Drops the view from the given schema.
Specifies view name to be dropped.
Specifies schema of the view to be dropped. If schema is not specified, function drops view from the current
Default Value: None
True - if the operation is successful.
TeradataMlException - If the view doesn't exist.
# 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')