DB/MariaDB
-
db object listDB/MariaDB 2020. 6. 8. 23:15
MariaDB, MySQL 내 db, table, column, index, constraints를 조회하는 query 이다. -- db SELECT db.schema_name , db.default_character_set_name , db.default_collation_name , COUNT(tbl.table_name) AS tbl_cnt FROM information_schema.schemata AS db LEFT OUTER JOIN information_schema.tables AS tbl ON db.schema_name = tbl.table_schema WHERE db.schema_name NOT IN ('information_schema', 'mysql', 'performance_schema..