数据仓库服务 GAUSSDB(DWS)-COMMENT:示例

时间:2024-10-21 16:50:37

示例

为customer.c_customer_sk列加注释:

1
COMMENT ON COLUMN customer.c_customer_sk IS 'Primary key of customer demographics table.';

tpcds.customer_details_view_v2视图加注释:

1
COMMENT ON VIEW tpcds.customer_details_view_v2 IS 'View of customer detail';

为customer表加注释:

1
COMMENT ON TABLE customer IS 'This is my table';
support.huaweicloud.com/sqlreference-830-dws/dws_06_0154.html