Skip to main content
Question

Can we add data descriptions to data or make data dictionary in Vertica?

  • August 3, 2022
  • 1 reply
  • 4 views

otsmartin

Can we add data descriptions to data or make data dictionary in Vertica?

1 reply

Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • August 3, 2022

Vertica supports COMMENT ON statements to store annotations on many objects. Please see the available labels at:
https://www.vertica.com/docs/11.1.x/HTML/Content/Authoring/SQLReferenceManual/Statements/COMMENT/COMMENTONStatements.htm
Some tools like DbVisualizer can read and update object comments.