To enhance read performance and reduce disk usage, TiDB automatically schedules data compaction on storage nodes in the background. During the compaction, storage nodes rewrite physical data, ...

When you alter the attributes of a column and an index has been defined for that column, the values in the altered column continue to have the index defined for them. If you drop a column with the ...

TiDB/TiKV/PD documentation. Contribute to jiyulongxu/docs-1 development by creating an account on GitHub.

This statement can be embedded in an application program or issued through the use of dynamic SQL statements. It is an executable statement that can be dynamically prepared. ... ALTER TABLE EMPLOYEE ...

Adding a primary key using alter command:alter command is generally used to modify table . it can be used to add columns or to remove columns. using alter command we can also add or remove a key from ...