none
Unable to view SQL database descriptions from Azure Data Catalog RRS feed

  • Question

  • Hi Azure,

    I have a table where the extendedproperties were set.  Had this table registered through Azure Data Catalog, but i'm unable to to view the column descriptions.  Is there any setting that I could have missed?  Any help will be appreciated?

    Scripts + references included.

    Thank you.

    Kenneth

    CREATE TABLE dbo.Testing
    (
    TestID INT
    , TestCode VARCHAR(10)
    , TestDescription VARCHAR(20)
    )

    EXEC sp_addextendedproperty   
        @name = N'ms_description'  
        ,@value = N'Unique ID for the test'  
        ,@level0type = N'Schema', @level0name = dbo  
        ,@level1type = N'Table',  @level1name = Testing  
        ,@level2type = N'Column', @level2name = TestID;  
    GO  

    EXEC sp_addextendedproperty   
        @name = N'ms_description'
        ,@value = N'Code for the Test'  
        ,@level0type = N'Schema', @level0name = dbo  
        ,@level1type = N'Table',  @level1name = Testing  
        ,@level2type = N'Column', @level2name = TestCode;  
    GO  

    

    Monday, June 17, 2019 6:23 AM

All replies