Add LIMIT Option to SHOW Query

Why it matters

The feature helps users to limit the output size of SHOW queries, making it easier to inspect and manage large sets of metadata without overwhelming the client or terminal.

How to use it

Append the LIMIT clause followed by a number to any SHOW query. For example:

SHOW TABLES LIMIT 10;