Default Value

How do you give a Column a default value when creating a DB Table?USE Northwind
GO

CREATE TABLE myTable99(
Col1 int IDENTITY(1,1)
, Col2 char(1) DEFAULT 'Y'
, Col3 datetime DEFAULT GetDate()
, Col4 sysname DEFAULT USER
, Col5 varchar(255)
, CONSTRAINT Col2_Check CHECK (Col2 IN ('Y','N'))
, CONSTRAINT Col1_PK PRIMARY KEY(Col1)
)
GO

INSERT INTO myTable99(Col5) SELECT 'TEST ROW 1'

SELECT * FROM myTable99
GO

DROP TABLE myTable99
GO