Teradata Package for Python Function Reference | 20.00 - db_drop_table - 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
- VMware
- Enterprise
- IntelliFlex
- Product
- Teradata Package for Python
- Release Number
- 20.00.00.11
- Publication Date
- August 2026
- Content Type
- Programming Reference
- Publication ID
- B700-4008-200K
- ft:locale
- en-US
- ft:lastEdition
- 2026-08-13
- ft:sourceId
- FTML
- dita:id
- TeradataPython_FxRef_Enterprise_2000
- Product Category
- Teradata Vantage
- teradataml.dbutils.dbutils.db_drop_table = db_drop_table(table_name, schema_name=None, suppress_error=False, datalake_name=None, purge=None)
- DESCRIPTION:
Drops the table from the given schema.
PARAMETERS:
table_name:
Required Argument
Specifies the table name to be dropped.
Types: str
schema_name:
Optional Argument
Specifies schema of the table to be dropped. If schema is not specified, function drops table from the
current database.
Default Value: None
Types: str
suppress_error:
Optional Argument
Specifies whether to raise error or not.
Default Value: False
Types: str
datalake_name:
Optional Argument
Specifies name of the datalake to drop table from.
Note:
"schema_name" must be provided while using this argument.
Default Value: None
Types: str
purge:
Optional Argument
Specifies whether to use purge clause or not while dropping datalake table.
It is only applicable when "datalake_name" argument is used. When "datalake_name" is specified,
but "purge" is not specified, data is purged by default.
Default Value: None
Types: bool
RETURNS:
True - if the operation is successful.
RAISES:
TeradataMlException - If the table doesn't exist.
EXAMPLES:
>>> load_example_data("dataframe", "admissions_train")
# Example 1: Drop table in current database.
>>> db_drop_table(table_name = 'admissions_train')
# Example 2: Drop table from the given schema.
>>> db_drop_table(table_name = 'admissions_train', schema_name = 'alice')
#Example 3: Drop a table from datalake and purge the data.
>>> db_drop_table(table_name = 'datalake_table', schema_name = 'datalake_db',
... datalake_name='datalake', purge=True)