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

3 votes246 views1 answer
Oracle user privileges
SQL
0 vote253 views1 answer
Trigger stock phpmyadmin
SQL
-1 vote212 views10 answers
Delete Query in SQL Server
SQL
8 votes221 views3 answers
Mysql alter table add index
SQL
0 vote233 views1 answer
Mysql count by month
SQL
13 votes269 views3 answers
Mysqldump structure only
SQL
0 vote239 views1 answer
Max mysql
SQL
1 vote225 views1 answer
Mysql order by desc null last
SQL
1 vote257 views2 answers
Oracle create synonym
SQL
0 vote243 views1 answer
Into operator in sql
SQL