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 vote340 views1 answer
Error code 1175 mysql fix
SQL
14 votes343 views4 answers
Online sql compiler
SQL
0 vote342 views1 answer
Oracle change password expiration policy
SQL
0 vote325 views1 answer
Get first name and last name from full name string in SQL
SQL
1 vote317 views1 answer
How to select random rows from table
SQL
0 vote366 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
3 votes343 views3 answers
Start postgresql ubuntu
SQL
0 vote358 views1 answer
Execute sql stored procedure in powershell
SQL
31 votes354 views4 answers
Mysql grant execute
SQL
1 vote361 views1 answer
Update substring in mysql
SQL