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

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
jpx1556733107962.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

The following rule applies to the DROP STATISTICS statement.

  • If you drop the statistics on an object using explicit column specification, Teradata Database does not drop the object-level statistics for the object.

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