# Create table, verify, drop, verify gone
admin 'CREATE NAMESPACE test_ns'
admin 'CREATE TABLE test_ns::users { id: int4, name: utf8 }'
replicate
---
version: 2
query 'FROM system::tables FILTER {name == "users"}'
---
+---------+----------------+---------+------------------+
| id | namespace_id | name | primary_key_id |
+---------+----------------+---------+------------------+
| 16385 | 16385 | users | none |
+---------+----------------+---------+------------------+
admin 'DROP TABLE test_ns::users'
replicate
---
version: 3
query 'FROM system::tables FILTER {name == "users"}'
---
+------+----------------+--------+------------------+
| id | namespace_id | name | primary_key_id |
+------+----------------+--------+------------------+
+------+----------------+--------+------------------+