Answer Detail: RE: Add Not Null Column in a Table

GeekInterview.com > Interview Questions > Database > Sybase

Print |

Question: Add Not Null Column in a Table

Answer: How we can add a NotNull Column in a table by using alter command (without using default command)?

October 10, 2008 19:53:09	#1
UncaAlby	Member Since: October 2008 Total Comments: 13
RE: Add Not Null Column in a Table
First add the column as NULL. Then populate the column with non-null data. Then modify the column to NOT NULL. You may need to set dboption "select into" to True.

Back To Question