T-SQL Add Column

Sqlserver add column to table

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

Add a new column into table

ALTER TABLE table ADD [COLUMN] column_name;

Source: mysqltutorial.org

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

1 vote104 views2 answers
T-sql random number for each row
SQL
0 vote119 views1 answer
Add mysql database to power bi web
SQL
0 vote107 views1 answer
Get duplicate entry sql
SQL
2 votes151 views1 answer
Oracle Column Names of a table
SQL
0 vote111 views1 answer
Sqlalchemy one column of two has to be not null
SQL
1 vote109 views1 answer
Base64 encode sql server
SQL
11 votes107 views2 answers
Docker create postgres db
SQL
0 vote58 views1 answer
Get last run query sql server
SQL
0 vote102 views1 answer
Mysql db dump restore max file size issue
SQL
1 vote109 views1 answer
Mysql show queries running
SQL