Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Documenting Database Code: Structured Headers

    select that return all tables with column description

    SELECT

    sys.objects.name AS [Table Name]

    ,sys.columns.name AS [Column Name]

    ,sys.extended_properties.value AS [Description]

    FROM

    sys.objects LEFT JOIN

    sys.columns

    ON sys.objects.object_id = sys.columns.object_id LEFT JOIN...

Viewing post 1 (of 1 total)