davidradl commented on code in PR #27236: URL: https://github.com/apache/flink/pull/27236#discussion_r2523097537
########## docs/content/docs/dev/table/sql/show.md: ########## @@ -986,6 +988,29 @@ SHOW CREATE VIEW [catalog_name.][db_name.]view_name Show create view statement for specified view. +## SHOW MATERIALIZED VIEWS + +```sql +SHOW MATERIALIZED TABLES [ ( FROM | IN ) [catalog_name.]database_name ] [ [NOT] LIKE <sql_like_pattern> ] +``` + +Show all materialized tables for an optionally specified database. If no database is specified then the materialized tables are returned from the current database. Additionally, the output of this statement may be filtered by an optional matching pattern. + +**LIKE** +Show all materialized tables with given view name and optional `LIKE` clause, whose name is whether similar to the `<sql_like_pattern>`. Review Comment: whose name is whether similar to the -> whose name is similar to the -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
