Checking Table Consistency

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

  1. In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
  2. 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
  3. Select the table for which to check consistency.
  4. Select Check Consistency.
    You see the Check Consistency wizard.
  5. Select Choose DBCC options.
  6. (Optional) 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.
  7. (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.
  8. (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.
  9. (Optional) Select Fix text.
    Fix text is used only for tables that contain text data. Select if you are changing to a new multibyte character set from either a single-byte or a multibyte character set.
  10. Select the type of allocation report.
  11. Click Finish to execute the selected commands.
Parent topic: Manage Tables