default value -- best practice question

Started by Aurangzeb M. Aghaover 23 years ago1 messagesgeneral
Jump to latest
#1Aurangzeb M. Agha
aagha@bigfoot.com

I'm adding a new column to one of my tables and wanted to know if there's
any need for me to set a default value since the type of the column is
'int'.

sql1: alter table todo add column clubmusictypeid int;

sql2: alter table todo alter column clubmusictypeid set default 0;

In general (given a column of type int), is it alright to just do sql1 and
forget about setting a default, or are there advantages to defaulting to
0. I'm presuming that if no default is set, the default is null?

Thx in Advance,
Aurangzeb

--
Aurangzeb M. Agha | Email : aagha@bigfoot.com
PGP ID: 0x68B3A763 |

"Those who would give up essential liberty to purchase a little
temporary safety deserve neither liberty nor safety."

- Benjamin Franklin