17.10 - Rules and Restrictions for DROP STATISTICS - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
The following rule applies to the DROP STATISTICS statement.
  • If you drop the statistics on an object using explicit column specification, Vantage does not drop the object-level statistics for the object.

    To do this, you must use the object-level DROP STATISTICS syntax.