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

0 vote122 views1 answer
Update if else mysql
SQL
0 vote187 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote127 views1 answer
Ms Sql set us timezone
SQL
0 vote135 views1 answer
Oracle drop type
SQL
12 votes124 views3 answers
Install sqlite driver ubuntu
SQL
0 vote130 views1 answer
Execute sql stored procedure in powershell
SQL
1 vote126 views2 answers
Sql server backup table
SQL
0 vote137 views1 answer
Stored procedures example
SQL
0 vote127 views1 answer
Get yesterday date ISO in psql
SQL
1 vote149 views1 answer
How to see all table partition in oracle
SQL