[
https://issues.apache.org/jira/browse/FLINK-29679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17619932#comment-17619932
]
Yubin Li edited comment on FLINK-29679 at 10/19/22 2:15 AM:
------------------------------------------------------------
[~luoyuxia] table's comment is a table level prop, we could use `show create
table <table_name>` to display table's comment as follow:
```
CREATE TABLE `default_catalog`.`default_database`.`t2` (
`id` INT
) COMMENT 'hello2'
WITH (
'connector' = 'print'
)
```
`DESCRIBE` statement shows column level props, such as column's comment.
was (Author: liyubin117):
[~luoyuxia] table's comment is a table level prop, we could use `show create
table <table_name>` to display table's comment, eg:
```
CREATE TABLE `default_catalog`.`default_database`.`t2` (
`id` INT
) COMMENT 'hello2'
WITH (
'connector' = 'print'
)
```
`DESCRIBE` statement shows column level props, such as column's comment.
> DESCRIBE statement shows column comment
> ---------------------------------------
>
> Key: FLINK-29679
> URL: https://issues.apache.org/jira/browse/FLINK-29679
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / API
> Affects Versions: 1.17.0
> Reporter: Yubin Li
> Assignee: Yubin Li
> Priority: Major
>
> comment is very helpful to make table schema user-friendly, many data
> analysers rely on such message to write sql adaptive to corresponding
> business logics.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
