Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

ADD COLUMN IN SQL SERVER

ALTER TABLE table_name
ADD column_name INT -- datatype

-- With default vaue and not nullable
ALTER TABLE table_name
ADD column_name BIT DEFAULT 0 NOT NULL -- 
 
PREVIOUS NEXT
Tagged: #ADD #COLUMN #IN #SQL #SERVER
ADD COMMENT
Topic
Name
1+6 =