테이블 필드에 설명 추가 하기 > db

DECLARE @v sql_variant
SET @v = N'새로운설명을넣는거'
EXECUTE testdb..sp_addextendedproperty N'MS_Description', @v, N'user', N'dbo', N'table', N'a', N'column',
N'bb'

DECLARE @v sql_variant
SET @v = N'testdb의bb컬럼의설명수정'
EXECUTE testdb..sp_updateextendedproperty N'MS_Description', @v, N'user', N'dbo', N'table', N'a',
N'column', N'bb'

-- 설명이 저장되는 테이블
select * from sysproperties
id
int
no                                  4           10    0     no                                  (n/a)
(n/a)                               NULL
smallid
smallint
no                                  2           5     0     no                                  (n/a)
(n/a)                               NULL
type
tinyint
no                                  1           3     0     no                                  (n/a)
(n/a)                               NULL
name
sysname
no                                  256                     no                                  (n/a)
(n/a)                               Korean_Wansung_CI_AS
value                                                                                                                            sql_variant

-- 아이디를 이용한 테이블 이름 찾기
select object_name('1730105204')