Post reply

Changing NULLABLE columns to NOT NULLABLE

  • June 9, 2010 at 10:06 pm

    #100259

    Hi

    i need to change 15 nullable columns to not-nullable in 15 millions record's table.whats the better way to acheive this ?

    i tried it with ALTER TABLE ..ALTER COLUMN approach but it was taking hours.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • June 9, 2010 at 10:28 pm

    #1178415

    Hi,

    Are you try to change the data available from null to desired record, or try to change the table schema?

  • June 9, 2010 at 10:38 pm

    #1178420

    no that columns dont contain any data

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

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