MSSQL GET TABLE COLUMN AND MS_Description / MS-SQL 테이블 컬럼 및 테이블 설명 가져오기

SELECT D.COLORDER AS COLUMN_IDX -- Column Index , A.NAME AS TABLE_NAME -- Table Name , C.VALUE AS TABLE_DESCRIPTION -- Table Description , D.NAME AS COLUMN_NAME -- Column Name , E.VALUE AS COLUMN_DESCRIPTION -- Column Description , F.DATA_TYPE AS TYPE -- Column Type , F.CHARACTER_OCTET_LENGTH AS LENGTH -- Column Length , F.IS_NULLABLE AS IS_NULLABLE -- Column Nullable , F.COLLATION_NAME AS COLLA..

2022.01.11