Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DROP STATISTICS (SQL Server Compact)
Collapse the table of content
Expand the table of content

DROP STATISTICS (SQL Server Compact)

Drops statistics for the specified table and index.


DROP STATISTICS ON < table_name > [ . <index_name> ]

table_name

Specifies the name of the table to drop the statistics from.

index_name

The index to drop the statistics from. If no index is specified, the statistics are dropped for all indexes in the table.

The following example demonstrates how to drop an index, create an index, and drop statistics for a specified table and index.

DROP INDEX Orders.emp_id_ind;
CREATE INDEX emp_id_ind ON Orders ([Employee ID]);
DROP STATISTICS ON Orders.emp_id_ind;
Show:
© 2015 Microsoft