아래와 같은 방법으로 주석을 달고 삭제하며조회가 가능하다. <div class="txc-textbox" style="border-style: solid; border-width: 1px; border-color: rgb(254, 254, 184); background-color: rgb(254, 254, 184); padding: 10px;">--테이블 코멘트 추가

EXEC sp_addextendedproperty 'MS_Description', '테이블설명', 'USER', DBO, 'TABLE', 테이블이름

--테이블 코멘트 삭제

EXEC sp_dropextendedproperty 'MS_Description', 'SCHEMA', DBO, 'TABLE', 테이블이름, DEFAULT,
DEFAULT

&nbsp;

&nbsp;

-- 칼럼 코멘트 추가

EXEC sp_addextendedproperty 'MS_Description', '컬럼설명', 'USER', DBO, 'TABLE', 테이블이름, 'COLUMN',
칼럼이름

-- 칼럼 코멘트 삭제

EXEC sp_dropextendedproperty 'MS_Description', 'SCHEMA', DBO, 'TABLE', 테이블이름, 'COLUMN',
칼럼이름

&nbsp;

&nbsp;

--테이블 코멘트 조회

SELECT OBJTYPE, OBJNAME, NAME, VALUE

FROM ::FN_LISTEXTENDEDPROPERTY (NULL, 'SCHEMA', 'DBO', 'TABLE', '테이블이름', DEFAULT, DEFAULT)

&nbsp;

--컬럼 코멘트 조회

SELECT OBJTYPE, OBJNAME, NAME, VALUE

FROM ::FN_LISTEXTENDEDPROPERTY(NULL,
'SCHEMA', 'DBO', 'TABLE', '테이블이름', 'COLUMN', DEFAULT)

&nbsp;

&nbsp;

-- 전체 테이블 코멘트 조회

SELECT

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NAME

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , (SELECT VALUE FROM SYS.EXTENDED_PROPERTIES WHERE MAJOR_ID = A.ID AND MINOR_ID = 0 ) COMMENT

FROM SYSOBJECTS
A

WHERE RTRIM(A.XTYPE) = 'U'

ORDER BY
NAME

&nbsp;

&nbsp;

-- 전체 테이블 별 칼럼 코멘트 조회

SELECT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; u.name + '.' + t.name AS [table],

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; td.value
AS [table_desc],

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c.name
AS [column],

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cd.value
AS [column_desc]

FROM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sysobjects
t

INNER JOIN&nbsp; sysusers u

&nbsp;&nbsp;&nbsp; ON&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; u.uid = t.uid

LEFT OUTER
JOIN sys.extended_properties
td

&nbsp;&nbsp;&nbsp; ON&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; td.major_id
= t.id

&nbsp;&nbsp;&nbsp; AND&nbsp;&nbsp;&nbsp;&nbsp; td.minor_id
= 0

&nbsp;&nbsp;&nbsp; AND&nbsp;&nbsp;&nbsp;&nbsp; td.name = 'MS_Description'

INNER JOIN&nbsp; syscolumns c

&nbsp;&nbsp;&nbsp; ON&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c.id = t.id

LEFT OUTER
JOIN sys.extended_properties
cd

&nbsp;&nbsp;&nbsp; ON&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cd.major_id
= c.id

&nbsp;&nbsp;&nbsp; AND&nbsp;&nbsp;&nbsp;&nbsp; cd.minor_id
= c.colid

&nbsp;&nbsp;&nbsp; AND&nbsp;&nbsp;&nbsp;&nbsp; cd.name = 'MS_Description'

WHERE t.type = 'u'

ORDER BY&nbsp;&nbsp;&nbsp; t.name, c.colorder

&nbsp;</div>

[MSSQL] 테이블 및 칼럼에 코멘트/주석 달고 조회하기 comment