how to set default value in table column in sql server code example

Example 1: set default column value sql

Name Varchar(255) default "Fred"

Example 2: add column alter table default value

ALTER TABLE PERSON
ADD IS_ACTIVE VARCHAR2(1) DEFAULT 'N' NOT NULL