Extended property Description

  • How can I retrieve the values for the Description Property for a tables columns?

    I mean with a T-sql statement.

    AW


    AW

  • SELECT SysProperties.Value

    FROMSysProperties

    INNER JOIN SysColumns ON SysProperties.id = SysColumns.id AND

    SysColumns.colid = SysProperties.smallid

    WHERE (SysProperties.name = 'MS_Description') AND

    (Object_name(Syscolumns.id) = <TableName>) AND

    (SysColumns.Name = <Columnname>)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply