docs icon indicating copy to clipboard operation
docs copied to clipboard

sql: support NOT VISIBLE in CREATE TABLE for user-defined hidden columns

Open jseldess opened this issue 4 years ago • 0 comments

Jesse Seldess commented:

PR: https://github.com/cockroachdb/cockroach/pull/58923

From release notes:

It is now possible to use the NOT VISIBLE qualifier for new column definitions in [CREATE TABLE](../v21.1/create-table.html]. This causes the column to become "hidden". Hidden columns are not considered when using * in SELECT clauses. Note that CockroachDB already supported hidden columns (e.g., rowid, which is added automatically when a table definition has no PRIMARY KEY constraint]. This change adds the opportunity for end-users to define their own hidden columns. It is intended for use in combination with other features related to geo-partitioning introduced in v21.1, which offer more control about how geo-partitioning keys get exposed to client ORMs and other automated tools that inspect the SQL schema. [#58923)[#58923) {% comment %}doc{% endcomment %}

Jira Issue: DOC-1045

jseldess avatar Mar 23 '21 14:03 jseldess