카테고리 없음
Description 추가/수정
탑~!
2026. 4. 30. 09:51
-- 테이블
EXEC sp_addextendedproperty 'MS_Description' , @DESCEIPTION , 'user' , @USER_NAME , 'table' , @TABLE_NAME
GO
EXEC sp_updateextendedproperty 'MS_Description' , @DESCEIPTION , 'user' , @USER_NAME , 'table', @TABLE_NAME
GO
-- 칼럼
-- 디스크립션 입력
EXEC sp_addextendedproperty 'MS_Description' , @DESCEIPTION , 'user' , @USER_NAME , 'table' , @TABLE_NAME, 'column' , @COL_NAME
GO
-- 디스크립션 수정
EXEC sp_updateextendedproperty 'MS_Description' , @DESCEIPTION , 'user' , @USER_NAME , 'table' , @TABLE_NAME, 'column' , @COL_NAME
GO
728x90
반응형