SELECT A.TABLE_NAME,B.TABLE_COMMENT,A.ORDINAL_POSITION,A.COLUMN_NAME,A.COLUMN_COMMENT,A.COLUMN_TYPE,A.COLUMN_KEY,A.IS_NULLABLE,A.COLUMN_DEFAULTFROM information_schema.COLUMNS A,information_schema.TABLES BWHERE A.TABLE_NAME = B.TABLE_NAMEAND B.TABLE_SCHEMA = A.TABLE_SCHEMAAND A.TABLE_SCHEMA = '디비명'ORDER BY A.TABLE_NAME, B.TABLE_COMMENT, A.ORDINAL_POSITION
태그 : mysql
최근 덧글