-
Notifications
You must be signed in to change notification settings - Fork 3
Expand file tree
/
Copy pathcomment_on.sql
More file actions
26 lines (15 loc) · 853 Bytes
/
comment_on.sql
File metadata and controls
26 lines (15 loc) · 853 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
-- column
comment on column employees.employee_id is 'Primary key of employees table.';
comment on column hr.employees.employee_id is 'Multiline
comment on column.';
comment on column "hr"."employees"."employee_id" is 'Primary key of employees table.';
-- add example: fix when comment on column with schema, the parser is report syntax error
comment on column s.a.c1 is 'comment';
-- table
comment on table employees is 'employees table. Contains 107 rows.';
comment on table hr.employees is 'employees table. Contains 107 rows.';
comment on table "hr"."employees" is 'employees table. Contains 107 rows.';
comment on table "my schema"."my table" is 'Some demo table with space in its name
and a multiline comment.';
COMMENT ON MATERIALIZED VIEW "MONITOR"."SQL_ALERT_LOG_ERRORS" IS
'snapshot table for snapshot MONITOR.SQL_ALERT_LOG_ERRORS';