Post reply

description of view columns

  • June 12, 2011 at 11:19 pm

    #251847

    hello all.

    I need to access to description of view columns.I know to access description of table columns.please give me one script that show description of columns of views.

  • June 13, 2011 at 12:52 am

    #1337594

    use sp_columns <viewname>

  • June 14, 2011 at 3:14 pm

    #1338686

    elham_azizi_62 (6/12/2011)

    hello all.

    I need to access to description of view columns.I know to access description of table columns.please give me one script that show description of columns of views.

    SELECT

    COL.*

    FROM INFORMATION_SCHEMA.TABLES AS TAB

    INNER JOIN INFORMATION_SCHEMA.COLUMNS AS COL

    ON COL.TABLE_CATALOG = TAB.TABLE_CATALOG

    AND COL.TABLE_SCHEMA = TAB.TABLE_SCHEMA

    AND COL.TABLE_NAME = TAB.TABLE_NAME

    WHERE

    TAB.TABLE_TYPE = 'VIEW'

    ORDER BY

    COL.TABLE_CATALOG

    ,COL.TABLE_SCHEMA

    ,COL.TABLE_NAME

    ,COL.ORDINAL_POSITION

  • June 14, 2011 at 6:33 pm

    #1338733

    😀

    Best Regards,
    Ashkan

  • June 14, 2011 at 6:38 pm

    #1338736

    SELECT v1.name

    FROM sys.columns v1

    INNER JOIN sys.views v2 on V1.OBJECT_ID = V2.OBJECT_ID

    and V2.NAME = 'VIEWNAME'

    Best Regards,
    Ashkan

  • June 14, 2011 at 10:55 pm

    #1338758

    elham_azizi_62 (6/12/2011)

    hello all.

    I need to access to description of view columns.I know to access description of table columns.please give me one script that show description of columns of views.

    Gosh... they're so close to each other. Did you even try?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 6 posts - 1 through 5 (of 5 total)

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