v.23.4Improvement

Support SHOW TABLE Syntax Equivalent to SHOW CREATE TABLE

Support SHOW TABLE syntax meaning the same as SHOW CREATE TABLE. Closes #48580. #48591 (flynn).
Support for the SHOW TABLE command, which now behaves the same as SHOW CREATE TABLE.

Why it matters

This feature simplifies the syntax for retrieving the table creation statement by allowing users to use the shorter SHOW TABLE command instead of SHOW CREATE TABLE. It enhances usability and aligns with common SQL conveniences.

How to use it

To use this feature, simply execute the command:

SHOW TABLE <table_name>


This will return the same output as SHOW CREATE TABLE <table_name>.