db_drop_table() | Database Utilities | Teradata Python Package - db_drop_table() - Teradata Package for Python

Teradata® Package for Python User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for Python
Release Number
20.00
Published
March 2024
Language
English (United States)
Last Update
2024-04-09
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
dita:id
rkb1531260709148
Product Category
Teradata Vantage

Use the db_drop_table() function to drop a table from a given schema. Returns True if the operation is successful.

Required arguments:
  • table_name specifies the table name to be dropped.
Optional arguments:
  • schema_name specifies the database of the table to be dropped. If a database is not specified, the function drops table from the current database.

Example Prerequisites

  • Import the teradataml module:
    >>> from teradataml import *
  • Load example data:
    >>> load_example_data("dataframe", "admissions_train")

Example 1: Drop table "admissions_train" from current database

>>> db_drop_table(table_name = "admissions_train")
True

Example 2: Drop table "admissions_train" from schema "alice"

>>> db_drop_table(table_name = "admissions_train", schema_name = "alice")
True