Skip to main content
Removes the statistics collected on a column of a table by COLLECT STATISTICS. Queries against the table are then planned without statistics for that column. Dropping statistics requires read permission on the column; a user whose access to the table is limited to certain rows or columns can drop the statistics of any column they can read.
DROP STATISTICS Syntax

​
Parameters

<schema name>

Name of the schema containing the table whose statistics will be dropped

<table name>

Name of the table whose statistics will be dropped

<column name>

Name of the column whose statistics will be dropped; only one column can be given per statement

​
Examples

To drop the statistics on a column of a table:
DROP STATISTICS Example