목록테이블정의서 (1)

뽁

MySQL.테이블정의서 추출 쿼리문

-- USE INFORMATION_SCHEMA ; (DB들 선택하는 명령 입니다. USE DB명) SELECT A.TABLE_SCHEMA AS DB , A.TABLE_NAME AS Table_ID, A.TABLE_COMMENT AS Table_NAME , B.COLUMN_NAME AS Column_ID , B.COLUMN_COMMENT AS Column_Name , B.DATA_TYPE AS Data_Type , -- B.CHARACTER_MAXIMUM_LENGTH AS Col_Length, -- CHAR character type에 대해 문자 단위로 보고 싶으면 CHARACTER_MAXIMUM_LENGTH 를 사용하시면 됩니다. -- B.CHARACTER_OCTET_LENGTH AS Col_Length..
IT Cafe+/MySQL 2019. 9. 23. 15:08
Prev 1 Next