Chapter 10. Table and Database Operations
In the previous chapters, we dealt mostly with table fields. In this chapter, we will learn how to perform some operations that influence tables or databases as a whole. We will cover table attributes and how to modify them, and also discuss multi-table operations.
Various links that enable table operations have been put together on one sub-page of the Table view: Operations. Here is an overview of this sub-page:
During the lifetime of a table, it repeatedly gets modified, and so grows and shrinks. Outages may occur on the server, leaving some tables in a damaged state.
Using the Operations sub-page, we can perform various operations, but not every operation is available for every table type:
Check table: Scans all rows to verify that deleted links are correct. Also, a checksum is calculated to verify the integrity of the keys; we should get an 'OK' message if everything is all right.
Analyze table: Analyzes and stores the key...
