Teradata Package for Python Function Reference on VantageCloud Lake - 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 on VantageCloud Lake
- Deployment
- VantageCloud
- Edition
- Lake
- Product
- Teradata Package for Python
- Release Number
- 20.00.00.03
- Published
- December 2024
- ft:locale
- en-US
- ft:lastEdition
- 2024-12-19
- dita:id
- TeradataPython_FxRef_Lake_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')