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
- Release Date
- April 2021
- Content Type
- Programming Reference
- Publication ID
- English (United States)
- 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')