You can validate an index to ensure that every row referenced in the index actually exists in the table. For foreign key indexes, a validation check also ensures that the corresponding row exists in the primary table. This check complements the validity checking performed by the VALIDATE TABLE statement.
Validate tables or entire databases only when no connections are making changes to the database.
Connect to the database as a user with DBA authority, or as the owner of the table on which the index is created.
In the left pane, double-click Indexes.
Right-click the index and choose Validate.
Click OK.
Connect to the database as a user with DBA authority, or as the owner of the table on which the index is created.
Execute a VALIDATE INDEX statement.
Run a dbvalid command with the -i option specified.
Validate an index called EmployeeNames. If you supply a table name instead of an index name, the primary key index is validated.
VALIDATE INDEX EmployeeNames; |
See VALIDATE statement.
Validate an index called EmployeeNames. The -I option specifies that each object name given is an index.
dbvalid -I EmployeeNames |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |