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 vote160 views1 answer
How to dump .csv file into mysql
SQL
0 vote172 views1 answer
Create query in where clasue
SQL
1 vote155 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
7 votes180 views2 answers
Create index mysql cli
SQL
0 vote175 views1 answer
To Create directory
SQL
0 vote153 views1 answer
Watch mysql command line
SQL
0 vote150 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
16 votes172 views1 answer
Mssql int max value
SQL
3 votes178 views1 answer
Set default today mysql
SQL
0 vote178 views1 answer
Select multiple row from primary key sql
SQL