간단 테이블 명세 보기

SELECT TABLE_NAME
      ,ORDINAL_POSITION
      ,COLUMN_NAME
      ,DATA_TYPE
      ,CHARACTER_MAXIMUM_LENGTH
      ,IS_NULLABLE
      ,COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = '테이블명'
ORDER BY TABLE_NAME, ORDINAL_POSITION;