set column default value sql code example
Example 1: add column table sql default value
ALTER TABLE users
ADD visit_number INT DEFAULT 0;
Example 2: default number in sql
ALTER TABLE clients ADD Points INT DEFAULT 0
ALTER TABLE clients ADD CONSTRAINT points DEFAULT 0 FOR Points
Example 3: set default column value sql
Name Varchar(255) default "Fred"
Example 4: alter column to not null with default value sql server
ALTER TABLE SomeTable
ADD SomeCol Bit NULL
CONSTRAINT D_SomeTable_SomeCol
DEFAULT (0)
WITH VALUES
Example 5: how to check default value of column in sql server
SELECT object_definition(default_object_id) AS definition
FROM sys.columns
WHERE name ='colname'
AND object_id = object_id('dbo.tablename')