Discussion thread	https://lists.apache.org/thread/l5xx9lgg70y6cbktk810yv4xzx701b04
Vote thread
JIRA
Release

Please keep the discussion on the mailing list rather than commenting on the wiki (wiki discussions get unwieldy fast).

Motivation:

Currently flink sql auxiliary statements has supported some good features such as catalog/databases/table support.

...

Proposed Syntax Changes:

	before	after(under discussed)	Note
show catalogs	SHOW CATALOGS	SHOW CATALOGS[ [NOT] LIKE <sql_like_pattern> ]
show databases	SHOW DATABASES	SHOW DATABASES [ ( FROM \| IN ) catalog_name] [ [NOT] LIKE <sql_like_pattern> ]
show functions	SHOW [USER] FUNCTIONS	SHOW [USER] FUNCTIONS [ ( FROM \| IN ) [catalog_name.]database_name ] [ [NOT] LIKE <sql_like_pattern> ]
show views	SHOW VIEWS	SHOW VIEWS [ ( FROM \| IN ) [catalog_name.]database_name ] [ [NOT] LIKE <sql_like_pattern> ]
show modules	SHOW [FULL] MODULES	SHOW [FULL] MODULES [ [NOT] LIKE <sql_like_pattern> ]
show jars	SHOW JARS	SHOW JARS [ [NOT] LIKE <sql_like_pattern> ]	only work in SQL CLI or SQL Gateway.
show jobs	SHOW JOBS	SHOW JOBS [ [NOT] LIKE <sql_like_pattern> ]	only work in SQL CLI or SQL Gateway.
describe catalog	Not Support	{ DESCRIBE \| DESC } CATALOG catalog_name
describe database	Not Support	{ DESCRIBE \| DESC } DATABASE [catalog_name.]db_name
describe function	Not Support	{ DESCRIBE \| DESC } FUNCTION [catalog_name.][db_name.]function
describe query	Not Support	{ DESCRIBE \| DESC } [ QUERY ] input_statement

Because `TableEnvironment` is a `@publicEvolving Api`, we may add these override methods or add some SupportsXXX interface to support these features.

details to be added.

to be added

...