DBCC UPDATEUSAGE

Report and correct page and row count inaccuracies in catalog views, use this after upgrading a database.

Syntax
      DBCC UPDATEUSAGE ( database 
         [, {table | view}  [,{index} ] ] )
            [WITH [ NO_INFOMSGS ] [ , ] [COUNT_ROWS ] ] 

 Key:
   database    - 'database_name' or database_id or 0 (current db)
   NO_INFOMSGS - Suppress all information messages.
   COUNT_ROWS  - Update the row count column.

The table/view and indexes may be specified by 'name' (in single quotes) or ID.

If 0 is specified, the current database will be used.

Example

DBCC UPDATEUSAGE ('MyDatabase','MySchema.MyTable');
GO

“No matter how cynical you get, it is impossible to keep up” ~ Lily Tomlin

Related:

sp_spaceused
sys.sysindexes
UPDATE STATISTICS
Equivalent Oracle command: DBA_TABLES - Rows in table , DBA_TAB_COL_STATISTICS - Other column stats


© Copyright SS64.com 1999-2014
Some rights reserved