Not Null field script

[abcurl]

I have 2 columns in the table. Want to create script for new column, and it's IS_Nullable value should be No. Can u please provide me teh script to do so?

[i i i]

if not exists(Select * from syscolumns where name ='yourfldname' and id in(Select id from Sysobjects where xtype ='U' and name ='yourtablename')) ALTER TABLE yourtablename add yourfieldname bit default(0) not NULL

Best Of Regards, SOFTDEV Sad like books with torn pages, sad like unfinished stories ...