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)