docs
docs copied to clipboard
sql: support NOT VISIBLE in CREATE TABLE for user-defined hidden columns
Jesse Seldess commented:
PR: https://github.com/cockroachdb/cockroach/pull/58923
From release notes:
It is now possible to use the
NOT VISIBLEqualifier 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*inSELECTclauses. Note that CockroachDB already supported hidden columns (e.g.,rowid, which is added automatically when a table definition has noPRIMARY KEYconstraint]. 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