tsql default column value code example Example: alter table add column with default value ALTER TABLE Protocols ADD ProtocolTypeID int NOT NULL DEFAULT(1)