Summary of default values in Vertica database

Query below summarizes default constraints in a database listing all distinct default value definitions for columns with the number of their occurrence.


select column_default,
       count(distinct table_id) as tables,
       count(column_name) as columns
from v_catalog.columns
group by column_default
order by count(column_name) desc;


  • column_default - definition of default constraint (formula)
    • [NULL] for identity columns
    • blank column default means default constaint was not defined
  • tables - number of tables with this constraint (or number of tables with columns with no constraints for blank row)
  • columns - number of columns with this particular constraint (or no constraint for blank row)


  • One row represents one unique definition of default value
  • Scope of rows: all distinct definitions of default column values in a database
  • Ordered by the number of occurrences from the most popular

Sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.