How to set Default value?

[croiva25]

I need to add a field to an table in sql db that has to have a default value. HOw can I assing the default value to a field in a table please?

Thanks

 

[gmmastros]

Alter table [blue]table1[/blue]
add [blue]ColumnName[/blue] Integer NOT NULL DEfault [blue]7[/blue]

Alter Table [blue]Table1[/blue]
Add [blue]VarCharColumn[/blue] VarChar([blue]50[/blue]) NOT NULL Default [blue]'George'[/blue]

You will need to change the items in blue.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[jbenson001]

You can also use EM. Right click on the table and choose Design View. Then select the column and go to the properties window on the bottom of the screen and enter a default value there.