github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/system_namespace (about) 1 # LogicTest: !3node-tenant 2 query IITI rowsort 3 SELECT * FROM system.namespace 4 ---- 5 0 0 defaultdb 50 6 0 0 postgres 51 7 0 0 system 1 8 0 0 test 52 9 1 0 public 29 10 1 29 comments 24 11 1 29 descriptor 3 12 1 29 eventlog 12 13 1 29 jobs 15 14 1 29 lease 11 15 1 29 locations 21 16 1 29 namespace 2 17 1 29 namespace2 30 18 1 29 protected_ts_meta 31 19 1 29 protected_ts_records 32 20 1 29 rangelog 13 21 1 29 replication_constraint_stats 25 22 1 29 replication_critical_localities 26 23 1 29 replication_stats 27 24 1 29 reports_meta 28 25 1 29 role_members 23 26 1 29 role_options 33 27 1 29 settings 6 28 1 29 statement_bundle_chunks 34 29 1 29 statement_diagnostics 36 30 1 29 statement_diagnostics_requests 35 31 1 29 table_statistics 20 32 1 29 tenants 8 33 1 29 ui 14 34 1 29 users 4 35 1 29 web_sessions 19 36 1 29 zones 5 37 50 0 public 29 38 51 0 public 29 39 52 0 public 29 40 41 # Verify format of system tables. 42 query TTBTTTB 43 SHOW COLUMNS FROM system.namespace 44 ---- 45 parentID INT8 false NULL · {primary} false 46 name STRING false NULL · {primary} false 47 id INT8 true NULL · {} false