상세 컨텐츠

본문 제목

칼럼 Comment

DataBase/SQL Server

by 탑~! 2014. 4. 3. 17:28

본문

       exec sp_addextendedproperty 'T_CO_Item_DESC1' , '생성자' , 'user' , 'dbo' , 'table' , 'T_CO_Item' , 'column' , 'CREATOR' 

       exec sp_addextendedproperty 'T_CO_Item_DESC2' , '생성일자' , 'user' , 'dbo' , 'table' , 'T_CO_Item' , 'column' , 'CREATEDATE' 

       exec sp_addextendedproperty 'T_CO_Item_DESC3' , '수정자' , 'user' , 'dbo' , 'table' , 'T_CO_Item' , 'column' , 'UPDATER' 

       exec sp_addextendedproperty 'T_CO_Item_DESC4' , '수정일자' , 'user' , 'dbo' , 'table' , 'T_CO_Item' , 'column' , 'UPDATEDATE' 



  EXEC sp_updateextendedproperty @name = N'T_CO_Item_DESC', @value = '생성자',@level0type = N'Schema', @level0name = dbo, @level1type = N'Table',  @level1name = 'T_CO_Item', 

@level2type = N'Column', @level2name = 'CREATOR';

      

 EXEC sp_updateextendedproperty @name = N'MS_Description', @value = '관리자여부',@level0type = N'Schema', @level0name = dbo, @level1type = N'Table',  @level1name = 'T_SY_User', 

@level2type = N'Column', @level2name = 'MANAGER_YN';

 EXEC sp_addextendedproperty @name = N'MS_Description', @value = '사용여부',@level0type = N'Schema', @level0name = dbo, @level1type = N'Table',  @level1name = 'T_SY_User', 

@level2type = N'Column', @level2name = 'USE_YN';



select 

        st.name [Table],

        sc.name [Column],

        sep.value [Description]

    from sys.tables st

    inner join sys.columns sc on st.object_id = sc.object_id

    left join sys.extended_properties sep on st.object_id = sep.major_id

                                         and sc.column_id = sep.minor_id

                                         and sep.name = 'MS_Description'

관련글 더보기