Erwin 9.5 FE for SQL Server 2012 'Comments'

Comments

1 comment

  • Avatar
    Jason Shangold
    Correct Answer

    I got a help from friend. I need to select schema. then only, Erwin FE will include comments as 

     


    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ColumnDefintionHere' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TablenameXYZ', @level2type=N'COLUMN',@level2name=N'column1234'
    GO

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk