28장 INFORMATION_SCHEMA 테이블
목차
28.3.1 INFORMATION_SCHEMA 일반 테이블 참조
28.3.2 INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS 테이블
28.3.3 INFORMATION_SCHEMA APPLICABLE_ROLES 테이블
28.3.4 INFORMATION_SCHEMA CHARACTER_SETS 테이블
28.3.5 INFORMATION_SCHEMA CHECK_CONSTRAINTS 테이블
28.3.6 INFORMATION_SCHEMA COLLATIONS 테이블
28.3.7 INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY 테이블
28.3.8 INFORMATION_SCHEMA COLUMNS 테이블
28.3.8 INFORMATION_SCHEMA COLUMNS 테이블
28.3.9 INFORMATION_SCHEMA COLUMNS_EXTENSIONS 테이블
28.3.9 INFORMATION_SCHEMA COLUMNS_EXTENSIONS 테이블
28.3.10 INFORMATION_SCHEMA COLUMN_PRIVILEGES 테이블
28.3.10 INFORMATION_SCHEMA COLUMN_PRIVILEGES 테이블
28.3.11 INFORMATION_SCHEMA COLUMN_STATISTICS 테이블
28.3.11 INFORMATION_SCHEMA COLUMN_STATISTICS 테이블
28.3.12 INFORMATION_SCHEMA ENABLED_ROLES 테이블
28.3.12 INFORMATION_SCHEMA ENABLED_ROLES 테이블
28.3.13 INFORMATION_SCHEMA ENGINES 테이블
28.3.13 INFORMATION_SCHEMA ENGINES 테이블
28.3.14 INFORMATION_SCHEMA EVENTS 테이블
28.3.14 INFORMATION_SCHEMA EVENTS 테이블
28.3.15 INFORMATION_SCHEMA FILES 테이블
28.3.15 INFORMATION_SCHEMA FILES 테이블
28.3.16 INFORMATION_SCHEMA KEY_COLUMN_USAGE 테이블
28.3.16 INFORMATION_SCHEMA KEY_COLUMN_USAGE 테이블
28.3.17 INFORMATION_SCHEMA KEYWORDS 테이블
28.3.17 INFORMATION_SCHEMA KEYWORDS 테이블
28.3.18 INFORMATION_SCHEMA ndb_transid_mysql_connection_map 테이블
28.3.18 INFORMATION_SCHEMA ndb_transid_mysql_connection_map 테이블
28.3.19 INFORMATION_SCHEMA OPTIMIZER_TRACE 테이블
28.3.19 INFORMATION_SCHEMA OPTIMIZER_TRACE 테이블
28.3.20 INFORMATION_SCHEMA PARAMETERS 테이블
28.3.20 INFORMATION_SCHEMA PARAMETERS 테이블
28.3.21 INFORMATION_SCHEMA PARTITIONS 테이블
28.3.21 INFORMATION_SCHEMA PARTITIONS 테이블
28.3.22 INFORMATION_SCHEMA PLUGINS 테이블
28.3.22 INFORMATION_SCHEMA PLUGINS 테이블
28.3.23 INFORMATION_SCHEMA PROCESSLIST 테이블
28.3.23 INFORMATION_SCHEMA PROCESSLIST 테이블
28.3.24 INFORMATION_SCHEMA PROFILING 테이블
28.3.24 INFORMATION_SCHEMA PROFILING 테이블
28.3.25 INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS 테이블
28.3.25 INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS 테이블
28.3.26 INFORMATION_SCHEMA RESOURCE_GROUPS 테이블
28.3.26 INFORMATION_SCHEMA RESOURCE_GROUPS 테이블
28.3.27 INFORMATION_SCHEMA ROLE_COLUMN_GRANTS 테이블
28.3.27 INFORMATION_SCHEMA ROLE_COLUMN_GRANTS 테이블
28.3.28 INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS 테이블
28.3.28 INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS 테이블
28.3.29 INFORMATION_SCHEMA ROLE_TABLE_GRANTS 테이블
28.3.29 INFORMATION_SCHEMA ROLE_TABLE_GRANTS 테이블
28.3.30 INFORMATION_SCHEMA ROUTINES 테이블
28.3.30 INFORMATION_SCHEMA ROUTINES 테이블
28.3.31 INFORMATION_SCHEMA SCHEMATA 테이블
28.3.31 INFORMATION_SCHEMA SCHEMATA 테이블
28.3.32 INFORMATION_SCHEMA SCHEMATA_EXTENSIONS 테이블
28.3.32 INFORMATION_SCHEMA SCHEMATA_EXTENSIONS 테이블
28.3.33 INFORMATION_SCHEMA SCHEMA_PRIVILEGES 테이블
28.3.33 INFORMATION_SCHEMA SCHEMA_PRIVILEGES 테이블
28.3.34 INFORMATION_SCHEMA STATISTICS 테이블
28.3.34 INFORMATION_SCHEMA STATISTICS 테이블
28.3.35 INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS 테이블
28.3.35 INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS 테이블
28.3.36 INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS 테이블
28.3.36 INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS 테이블
28.3.37 INFORMATION_SCHEMA ST_UNITS_OF_MEASURE 테이블
28.3.37 INFORMATION_SCHEMA ST_UNITS_OF_MEASURE 테이블
28.3.38 INFORMATION_SCHEMA TABLES 테이블
28.3.38 INFORMATION_SCHEMA TABLES 테이블
28.3.39 INFORMATION_SCHEMA TABLES_EXTENSIONS 테이블
28.3.39 INFORMATION_SCHEMA TABLES_EXTENSIONS 테이블
28.3.40 INFORMATION_SCHEMA TABLESPACES_EXTENSIONS 테이블
28.3.40 INFORMATION_SCHEMA TABLESPACES_EXTENSIONS 테이블
28.3.41 INFORMATION_SCHEMA TABLE_CONSTRAINTS 테이블
28.3.41 INFORMATION_SCHEMA TABLE_CONSTRAINTS 테이블
28.3.42 INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS 테이블
28.3.42 INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS 테이블
28.3.43 INFORMATION_SCHEMA TABLE_PRIVILEGES 테이블
28.3.43 INFORMATION_SCHEMA TABLE_PRIVILEGES 테이블
28.3.44 INFORMATION_SCHEMA TRIGGERS 테이블
28.3.44 INFORMATION_SCHEMA TRIGGERS 테이블
28.3.45 INFORMATION_SCHEMA USER_ATTRIBUTES 테이블
28.3.45 INFORMATION_SCHEMA USER_ATTRIBUTES 테이블
28.3.46 INFORMATION_SCHEMA USER_PRIVILEGES 테이블
28.3.46 INFORMATION_SCHEMA USER_PRIVILEGES 테이블
28.3.47 INFORMATION_SCHEMA VIEWS 테이블
28.3.47 INFORMATION_SCHEMA VIEWS 테이블
28.3.48 INFORMATION_SCHEMA VIEW_ROUTINE_USAGE 테이블
28.3.48 INFORMATION_SCHEMA VIEW_ROUTINE_USAGE 테이블
28.3.49 INFORMATION_SCHEMA VIEW_TABLE_USAGE 테이블
28.3.49 INFORMATION_SCHEMA VIEW_TABLE_USAGE 테이블
28.4 INFORMATION_SCHEMA InnoDB 테이블
28.4 INFORMATION_SCHEMA InnoDB 테이블
28.4.1 INFORMATION_SCHEMA InnoDB 테이블 참조
28.4.1 INFORMATION_SCHEMA InnoDB 테이블 참조
28.4.2 INFORMATION_SCHEMA INNODB_BUFFER_PAGE 테이블
28.4.2 INFORMATION_SCHEMA INNODB_BUFFER_PAGE 테이블
28.4.3 INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU 테이블
28.4.3 INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU 테이블
28.4.4 INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS 테이블
28.4.4 INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS 테이블
28.4.5 INFORMATION_SCHEMA INNODB_CACHED_INDEXES 테이블
28.4.5 INFORMATION_SCHEMA INNODB_CACHED_INDEXES 테이블
28.4.6 INFORMATION_SCHEMA INNODB_CMP 및 INNODB_CMP_RESET 테이블
28.4.6 INFORMATION_SCHEMA INNODB_CMP 및 INNODB_CMP_RESET 테이블
28.4.7 INFORMATION_SCHEMA INNODB_CMPMEM 및 INNODB_CMPMEM_RESET 테이블
28.4.7 INFORMATION_SCHEMA INNODB_CMPMEM 및 INNODB_CMPMEM_RESET 테이블
28.4.8 INFORMATION_SCHEMA INNODB_CMP_PER_INDEX 및 INNODB_CMP_PER_INDEX_RESET 테이블
28.4.8 INFORMATION_SCHEMA INNODB_CMP_PER_INDEX 및 INNODB_CMP_PER_INDEX_RESET 테이블
28.4.9 INFORMATION_SCHEMA INNODB_COLUMNS 테이블
28.4.9 INFORMATION_SCHEMA INNODB_COLUMNS 테이블
28.4.10 INFORMATION_SCHEMA INNODB_DATAFILES 테이블
28.4.10 INFORMATION_SCHEMA INNODB_DATAFILES 테이블
28.4.11 INFORMATION_SCHEMA INNODB_FIELDS 테이블
28.4.11 INFORMATION_SCHEMA INNODB_FIELDS 테이블
28.4.12 INFORMATION_SCHEMA INNODB_FOREIGN 테이블
28.4.12 INFORMATION_SCHEMA INNODB_FOREIGN 테이블
28.4.13 INFORMATION_SCHEMA INNODB_FOREIGN_COLS 테이블
28.4.13 INFORMATION_SCHEMA INNODB_FOREIGN_COLS 테이블
28.4.14 INFORMATION_SCHEMA INNODB_FT_BEING_DELETED 테이블
28.4.14 INFORMATION_SCHEMA INNODB_FT_BEING_DELETED 테이블
28.4.15 INFORMATION_SCHEMA INNODB_FT_CONFIG 테이블
28.4.15 INFORMATION_SCHEMA INNODB_FT_CONFIG 테이블
28.4.16 INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD 테이블
28.4.16 INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD 테이블
28.4.17 INFORMATION_SCHEMA INNODB_FT_DELETED 테이블
28.4.17 INFORMATION_SCHEMA INNODB_FT_DELETED 테이블
28.4.18 INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE 테이블
28.4.18 INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE 테이블
28.4.19 INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE 테이블
28.4.19 INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE 테이블
28.4.20 INFORMATION_SCHEMA INNODB_INDEXES 테이블
28.4.20 INFORMATION_SCHEMA INNODB_INDEXES 테이블
28.4.21 INFORMATION_SCHEMA INNODB_METRICS 테이블
28.4.21 INFORMATION_SCHEMA INNODB_METRICS 테이블
28.4.22 INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES 테이블
28.4.22 INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES 테이블
28.4.23 INFORMATION_SCHEMA INNODB_TABLES 테이블
28.4.23 INFORMATION_SCHEMA INNODB_TABLES 테이블
28.4.24 INFORMATION_SCHEMA INNODB_TABLESPACES 테이블
28.4.24 INFORMATION_SCHEMA INNODB_TABLESPACES 테이블
28.4.25 INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF 테이블
28.4.25 INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF 테이블
28.4.26 INFORMATION_SCHEMA INNODB_TABLESTATS 뷰
28.4.26 INFORMATION_SCHEMA INNODB_TABLESTATS 뷰
28.4.27 INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO 테이블
28.4.27 INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO 테이블
28.4.28 INFORMATION_SCHEMA INNODB_TRX 테이블
28.4.28 INFORMATION_SCHEMA INNODB_TRX 테이블
28.4.29 INFORMATION_SCHEMA INNODB_VIRTUAL 테이블
28.4.29 INFORMATION_SCHEMA INNODB_VIRTUAL 테이블
28.5 INFORMATION_SCHEMA 스레드 풀 테이블
28.5 INFORMATION_SCHEMA 스레드 풀 테이블
28.5.1 INFORMATION_SCHEMA 스레드 풀 테이블 참조
28.5.1 INFORMATION_SCHEMA 스레드 풀 테이블 참조
28.5.2 INFORMATION_SCHEMA TP_THREAD_GROUP_STATE 테이블
28.5.2 INFORMATION_SCHEMA TP_THREAD_GROUP_STATE 테이블
28.5.3 INFORMATION_SCHEMA TP_THREAD_GROUP_STATS 테이블
28.5.3 INFORMATION_SCHEMA TP_THREAD_GROUP_STATS 테이블
28.5.4 INFORMATION_SCHEMA TP_THREAD_STATE 테이블
28.5.4 INFORMATION_SCHEMA TP_THREAD_STATE 테이블
28.6 INFORMATION_SCHEMA 연결 제어 테이블
28.6 INFORMATION_SCHEMA 연결 제어 테이블
28.6.1 INFORMATION_SCHEMA 연결 제어 테이블 참조
28.6.1 INFORMATION_SCHEMA 연결 제어 테이블 참조
28.6.2 INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS 테이블
28.6.2 INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS 테이블
28.7 INFORMATION_SCHEMA MySQL Enterprise Firewall 테이블
28.7 INFORMATION_SCHEMA MySQL Enterprise Firewall 테이블
28.7.1 INFORMATION_SCHEMA 방화벽 테이블 참조
28.7.1 INFORMATION_SCHEMA 방화벽 테이블 참조
28.7.2 INFORMATION_SCHEMA MYSQL_FIREWALL_USERS 테이블
28.7.2 INFORMATION_SCHEMA MYSQL_FIREWALL_USERS 테이블
28.7.3 INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST 테이블
28.7.3 INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST 테이블
28.8 SHOW 문에 대한 확장
INFORMATION_SCHEMA
INFORMATION_SCHEMA는 데이터베이스 메타데이터, 즉 데이터베이스나 테이블의 이름, 열의 데이터 타입, 또는 접근 권한과 같은 MySQL 서버에 대한 정보를 제공합니다. 이 정보를 위해 때때로 사용되는 다른 용어로는 data dictionary와 system catalog가 있습니다.