# Create table in a nested namespace
admin 'CREATE NAMESPACE org::team'
admin 'CREATE TABLE org::team::metrics { ts: int8, val: float8 }'
replicate
---
version: 2
query 'FROM system::namespaces FILTER {name == "org" or name == "org::team"} SORT {name:ASC}'
---
+---------+-------------+--------------+-------------+
| id | name | local_name | parent_id |
+---------+-------------+--------------+-------------+
| 16385 | org | org | 0 |
| 16386 | org::team | team | 16385 |
+---------+-------------+--------------+-------------+
query 'FROM system::tables FILTER {name == "metrics"}'
---
+---------+----------------+-----------+------------------+
| id | namespace_id | name | primary_key_id |
+---------+----------------+-----------+------------------+
| 16385 | 16386 | metrics | none |
+---------+----------------+-----------+------------------+