docs icon indicating copy to clipboard operation
docs copied to clipboard

sql: show hidden columns in SHOW CREATE TABLE

Open jseldess opened this issue 4 years ago • 2 comments

Jesse Seldess commented:

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

From release notes:

Hidden columns (created by using NOT VISIBLE or implicitly created via hash sharded indexes, a lack of a primary key definition, or by using REGIONAL BY ROW) will now display with NOT VISIBLE annotations on [SHOW CREATE TABLE](../v21.1/show-create-table.html]. [#59828][#59828) {% comment %}doc{% endcomment %}

Jira Issue: DOC-1046

jseldess avatar Mar 23 '21 14:03 jseldess

IDK if we need to explicitly document this...

@rmloveland You okay with me closing this?

ericharmeling avatar May 12 '21 17:05 ericharmeling

I think we probably do need to at least mention this in docs. The reason is that the "hidden-ness" of the crdb_region column (or a computed column equivalent) is a thing one may need to have at least some understanding of, depending on what one is doing

However, as with some of the other small items I don't think this is blocking for the v21.1 release, can be a follow-up

rmloveland avatar May 12 '21 19:05 rmloveland