Teradata Package for Python Function Reference | 20.00 - 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 - 20.00
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Teradata Package for Python
- Release Number
- 20.00.00.04
- Published
- March 2025
- ft:locale
- en-US
- ft:lastEdition
- 2025-03-30
- dita:id
- TeradataPython_FxRef_Enterprise_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')