数据库扩展属性的使用

windy8848

CREATE TABLE TEST_TABLE ( id int , username char (20) , zjm char(10) );
GO
EXEC sp_addextendedproperty
    @name = 'fullname'
    ,@value = '姓名'
    ,@level0type = 'schema'
    ,@level0name = dbo
    ,@level1type = 'table'
    ,@level1name = 'TEST_TABLE'
    ,@level2type = 'column'
    ,@level2name = username;
GO
EXEC sp_dropextendedproperty
     @name = 'fullname'
    ,@level0type = 'schema'
    ,@level0name = dbo
    ,@level1type = 'table'
    ,@level1name = 'TEST_TABLE'
    ,@level2type = 'column'
    ,@level2name = username;
GO
DROP TABLE TEST_TABLE;
GO

select * from sys.extended_properties

ufmuyi

学习了，再练习下

collin

就是不懂什么用途，见笑了