Search This Blog

Add Column With Default Column Constraint to Table

I found many questions regarding the inline named default constraints in many user groups, its actually pretty simple

CREATE TABLE dbo.tempabc
[col1] [varchar] (16),
[col2] [int] NULL CONSTRAINT df__tempabc__Col2 DEFAULT ((0))

1 comment:

daspeac said...

it seems you have never heard about the sql server repair database tools download