Start CHECK TABLE in the SQLStudio.21. How do I start the database structure check with the DBMGUI?
You can start the database structure check in the DBMGUI using Check. a) ONLINE status: – ‘Check Database Structure’ checks the complete database. Using the EXTENDED option, you can activate further checks. Using the EXTENDED option, you can activate further checks. Usually you can accelerate the runtime of the check using this option. This means that no indexes are checked. If structural inconsistencies are detected in an index when the program is running, this is flagged as BAD and you can correct it using Delete and Create New. – ‘Check database structure for a selected table’: here you can restrict the check to individual tables. When you specify the table name, you cannot use any wildcards. If the table has blobs, you can use the option WITH LONG CHECK to check whether all defined LONG values defined there exist. Due to the transaction consistency, an SQL shared lock is requested for the duration of the check. b) ADMIN status ‘Check database structure and clear converter’ checks t
