Bong's

SELECT TABLE_NAME , ORDINAL_POSITION , COLUMN_NAME , DATA_TYPE , CHARACTER_MAXIMUM_LENGTH , IS_NULLABLE , COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS --FROM ［연결된서버］.INFORMATION_SCHEMA.COLUMNS --WHERE 1=1 --AND TABLE_NAME = ''

Program/DB 2020. 3. 29. 03:04