Checking Table Consistency

Check and repair the logical and physical consistency of a table.

  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
    • User Tables
    • Proxy Tables
    • System Tables
  2. Click the Name field of the table, then click the drop-down arrow and select Check Consistency.
  3. On the Choose DBCC options screen:
    1. Select Check overall consistency, then optionally click Ignore non-clustered indexes.
      Check overall consistency checks that:
      • Index and data pages are linked correctly.
      • Indexes are sorted properly.
      • Pointers are consistent.
      • All indexes and data partitions are correctly linked.
      • Data rows on each page have entries in the row-offset table.
      • Partition statistics for partitioned tables are correct.
    2. (Optional) Select Check allocation, then optionally click Fix allocation errors.
      Check allocation checks the table to ensure that:
      • All pages are correctly allocated.
      • Partition statistics on the allocation pages are correct.
      • No page is allocated that is not used.
      • All pages are correctly allocated to the partitions in the specified table and that allocated pages are used.
      • No unallocated page is used.
    3. (Optional) Select Reindex.
      This option allows the system administrator or table owner to check the integrity of indexes attached to a user table and to rebuild suspect indexes.
    1. (Optional; only for tables that contain text data) Select Fix text.
      Select this options if you are changing to a new multibyte character set from either a single-byte or a multibyte character set.
    2. Select the type of allocation report.
  4. Click Finish.