For Existing Table
ALTER TABLE dbo.tbTable01
ADD CONSTRAINT DF_tbTable01_biColumn01
DEFAULT 0 FOR biColumn01;
For New Table Definition
CREATE TABLE dbo.tbTable01
(
biColumn01 BIGINT NOT NULL CONSTRAINT DF_tbTable01_biColumn01 DEFAULT 0,
...
)
Comments