ALTER TABLE Employee ALTER COLUMN CityBorn SET DEFAULT 'SANDNES'
-- Syntax ALTER TABLE TABLE_NAME ADD COLUMN_NAME DATATYPE NULL|NOT NULL CONSTRAINT CONSTRAINT_NAME DEFAULT DEFAULT_VALUE -- Example ALTER TABLE Employee_Details ADD isacitve INT NULL CONSTRAINT DF_TABLE_COL_ISACTIVE DEFAULT '0'
ALTER TABLE Protocols ADD ProtocolTypeID int NOT NULL DEFAULT(1) GO
Alter table TestTable Add isWork bit not null Default(1)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)