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,
...
)
Last modified: September 28, 2021

Author

Comments

Write a Reply or Comment