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 vote253 views1 answer
Oracle winter time change
SQL
0 vote229 views2 answers
Sql use not in
SQL
0 vote219 views1 answer
Download mysql database to excel in android studio
SQL
0 vote246 views1 answer
Call object contructor and call methods of object
SQL
4 votes215 views1 answer
Oracle error compilation line
SQL
0 vote187 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
5 votes245 views2 answers
Oracle find all tables with column name
SQL
0 vote217 views1 answer
Get last updated row sql server
SQL
0 vote226 views1 answer
Add SuperUser MySQL
SQL
0 vote234 views1 answer
Character count sql
SQL