sql to set allow null

Question

can u help me 

I need sql query to set allow null propery of a colum ( true /false)

hw to do it 

---

bahushekh

Answer 1

Hi,

You can use alter statement

 

alter table tablename alter column columnname datatype null

 

However there are various considerations while changing the column to accept NOT NULL value!!!

---

Thanks and regards, Rishabh

Answer 2

You can use the following sql statment

ALTER TABLE tablename ALTER COLUMN columnname VARCHAR(50) NOT NULL

---

Thanks, A.m.a.L [MVP Visual C#] Dot Net Goodies
Don't hate the hacker, hate the code

Answer 3

go through the below link for more detail on modifying a table structure or column structure:

http://msdn.microsoft.com/en-us/library/ms190273.aspx

 

---

--------------------------------- Devender Bijania

Answer 4

To allow NULL use the below

--exist column

ALTER TABLE tbl ALTER COLUMN col INT NULL

--New column

ALTER TABLE tbl ADD col INT NULL

 

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/