<p>How can I add a column with a default value to an existing table in <a href="http://en.wikipedia.org/wiki/Microsoft_SQL_Server#Genesis" rel="noreferrer">SQL Server 2000</a> / <a href="http://en.wikipedia.org/wiki/Microsoft_SQL_Server#SQL_Server_2005" rel="noreferrer">SQL Server 2005</a>?</p>

```
```
ALTER TABLE ADD ColumnName {Column_Type} Constraint
```
```
The MSDN article
ALTER TABLE (Transact-SQL)
has all of the alter table syntax.