ALTER TABLE TB_INSP_IR_WORKTIME ADD VWM VARCHAR(50);
EXEC sys.sp_addextendedproperty
@name=N'MS_Description'
,@value=N'Visit : V, Weekly : W1/W2/W3/W4/W5, Monthly : M'
,@level0type=N'SCHEMA'
,@level0name=N'dbo'
,@level1type=N'TABLE'
,@level1name=N'TB_INSP_IR_WORKTIME'
,@level2type=N'COLUMN'
,@level2name=N'VWM'

==============================================

-- 테이블의 칼럼 type, description 정보 추출 쿼리

SELECT
 A.NAME AS [TABLE],
 B.NAME AS [COLUMN],
 C.NAME + '(' + CONVERT(VARCHAR, B.LENGTH) + ')' AS [TYPE],
 D.VALUE AS [DESCRIPTION]
FROM SYSOBJECTS A
 INNER JOIN SYSCOLUMNS B ON A.ID = B.ID
 INNER JOIN SYS.TYPES C ON B.XTYPE = C.SYSTEM_TYPE_ID
 INNER JOIN SYS.EXTENDED_PROPERTIES D ON A.ID = D.MAJOR_ID AND B.COLID = D.MINOR_ID
WHERE A.NAME = 'TB_MTS_MTRL_CFG'
ORDER BY B.COLID

ALTER TABLE TB_INSP_IR_WORKTIME ADD VWM VARCHAR(50);
EXEC sys.sp_addextendedproperty
@name=N'MS_Description'
,@value=N'Visit : V, Weekly : W1/W2/W3/W4/W5, Monthly : M'
,@level0type=N'SCHEMA'
,@level0name=N'dbo'
,@level1type=N'TABLE'
,@level1name=N'TB_INSP_IR_WORKTIME'
,@level2type=N'COLUMN'
,@level2name=N'VWM'

==============================================

-- 테이블의 칼럼 type, description 정보 추출 쿼리

SELECT
 A.NAME AS [TABLE],
 B.NAME AS [COLUMN],
 C.NAME + '(' + CONVERT(VARCHAR, B.LENGTH) + ')' AS [TYPE],
 D.VALUE AS [DESCRIPTION]
FROM SYSOBJECTS A
 INNER JOIN SYSCOLUMNS B ON A.ID = B.ID
 INNER JOIN SYS.TYPES C ON B.XTYPE = C.SYSTEM_TYPE_ID
 INNER JOIN SYS.EXTENDED_PROPERTIES D ON A.ID = D.MAJOR_ID AND B.COLID = D.MINOR_ID
WHERE A.NAME = 'TB_MTS_MTRL_CFG'
ORDER BY B.COLID