Can I change the settings on a SQL Server table for ANSI_NULL without dropping it?

Answer 1

ALTER table customer modify Addr char(30)

Thats how you change the customer table for the column ADDR, so you can just apply the same format to your table column.

You dont have to drop the table and create a new one just to alter the data type.


I just re-read your question. You want to set the whole TABLE to ANSI_NULL on?

You cant, Im sorry. You can only set it to ANSI_NULL during table creation. I thought you wanted to specify and modify a column to null.

You can just copy the entire table to a new table while setting the new table to ANSI_NULL. If you need help with it, just contact me. But you do have to drop the original table.