Post reply

Set default value for all the columns

  • February 27, 2009 at 3:11 am

    #201625

    I want to set the default value of the all columns of the table, if i have forget to set them default values while designing.i know how to set default value to a column while designing a table.

    is there any way to set all or selected columns default value? i want to set default value as "' '"

    Karun

  • March 2, 2009 at 2:01 am

    #951703

    Dynamic sql and.. alter table ... encaspulated in a ddl trigger.... not that I recommend doing that. If " " is really null.. why not just allow it to be null ?

    "Who then will explain the explanation? Who then will explain the explanation?" Lord Byron

  • March 3, 2009 at 11:19 pm

    #952878

    Try

    CREATE DEFAULT for each column

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

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