본문 바로가기

프로그래밍/MySql

MySQL 컬럼 정보 조회

SHOW FULL COLUMNS FROM TestTable;

 

 

SHOW COLUMNS FROM TestTable;
DESC TestTable;



SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA='TestDatabase' AND TABLE_NAME='TestTable';

 


SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA='TestDatabase' AND TABLE_NAME='TestTable';

 

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='TestTable';