Sqlserver add column

Sqlserver add column to table

ALTER TABLE dbo.doc_exa 
ADD column_b VARCHAR(20) NULL, 
	column_c INT NULL ;

Alter table add column

ALTER TABLE table_name 
ADD column_name datatype;

Sqlserver add column

ALTER TABLE myTable ADD newColumn bit NOT NULL default(0)

T-SQL Add Column

ALTER TABLE sales.quotations 
    ADD 
        amount DECIMAL (10, 2) NOT NULL,
        customer_name VARCHAR (50) NOT NULL;
Code language: SQL (Structured Query Language) (sql)

Source: sqlservertutorial.net

Similar codes

0 vote123 views1 answer
Mysql regex select
SQL
0 vote139 views1 answer
Sql server is not
SQL
0 vote108 views1 answer
Date datatype in livesql
SQL
0 vote118 views1 answer
Sql delimiter to columns
SQL
0 vote135 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote105 views1 answer
T-sql conditional order by multiple columns
SQL
26 votes105 views2 answers
What is the sql statement that finds duplicate usernames
SQL
14 votes109 views5 answers
Set password for postgres user ubuntu
SQL
0 vote120 views1 answer
Except in sql alchemy
SQL
0 vote104 views1 answer
Authentication in sql server
SQL