Post reply

Computed columns

  • April 22, 2003 at 2:26 pm

    #64591

    Hi all,

    I have a table which has computed columns defined on it.When i use EM to view the table desing or double click it i don't see these columns where as when i run sp_help for this table i can see that the column are exising.

    I have SQL2k with sp3 running on this server.

    AN dalso if i want to know whats the formula defined for these computed colums how can i get it.

    Thanks,

    kumari

  • April 23, 2003 at 8:59 am

    #455048

    Can't speak to the view through EM but, to get the formula I would GUESS that you could script out the table and see the computation associated with that column.

    Curious if that works so, let me know. Thanks.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • April 23, 2003 at 6:00 pm

    #455108

    You can run the stored procedure sp_mshelpcolumns 'tablename' and in the text column next to the col_iscomputed will appear the formula.

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

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