Maria DB ( MySQL) 스키마(Schema) 메타데이터 정보조회
-- 테이블 정보 및 찾기 쿼리 SELECT TABLE_SCHEMA , TABLE_NAME , TABLE_COMMENT , TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%%' ; -- 컬럼 정보 SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_COMMENT, COLUMN_TYPE, IS_NULLABLE, COLUMN_DEFAULT, COLUMN_KEY FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE '%%' ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION ; - Information_schema는..
