Home Forums SQL Server 7,2000 T-SQL Alter Table and Column to Allow Nulls RE: Alter Table and Column to Allow Nulls

  • I believe it is simply

    ALTER TABLE tblName ALTER COLUMN colName NULL

    on the table with the foreign key reference. Or are you wanting to enable allow nulls for the duration then put back as I don't believe you can if you column is null when done unless you are going to fix the data befor turning not null back on.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)