Alter Table and Column to Allow Nulls

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » Alter Table and Column to Allow Nulls

Alter Table and Column to Allow Nulls

Rate Topic

Display Mode

Topic Options

Author

Message

SB1

Posted Tuesday, April 23, 2002 11:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 14, 2003 12:00 AM
Points: 8, Visits: 1

What is the software command to modify the constraints on a foreign key to allow nulls and then restore the constraints?

Post #3742

Antares686

Posted Tuesday, April 23, 2002 12:47 PM

SSCrazy Eights

Group: Moderators
Last Login: Tuesday, April 09, 2013 12:53 PM
Points: 8,357, Visits: 684

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)

Post #32252

SB1

Posted Tuesday, April 23, 2002 1:10 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 14, 2003 12:00 AM
Points: 8, Visits: 1

The second part of your response answered my question (just as I thought).

Thank you for your prompt response.

Post #32253

« Prev Topic | Next Topic »

Permissions