v.23.4Improvement
Support SHOW TABLE Syntax Equivalent to SHOW CREATE TABLE
SupportSHOW TABLEsyntax meaning the same asSHOW CREATE TABLE. Closes #48580. #48591 (flynn).
Why it matters
This feature simplifies the syntax for retrieving the table creation statement by allowing users to use the shorterSHOW 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>.