KB-8E24
HC-REG unregistered tables query
1 min read Revision 1
health-checksqllaw-36fix25
-- HC-REG: Bảng PG public chưa đăng ký collection_registry -- DB: directus | Schema: public | Read-only SELECT t.table_name FROM information_schema.tables t WHERE t.table_schema = 'public' AND t.table_type = 'BASE TABLE' AND t.table_name NOT IN (SELECT collection_name FROM collection_registry) AND t.table_name NOT LIKE 'directus_%' AND t.table_name NOT LIKE 'pg_%' AND t.table_name NOT LIKE 'temp_%';