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 vote173 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote231 views1 answer
Sql get table last modified time
SQL
1 vote187 views3 answers
Drop unique key constraint in sql server
SQL
0 vote167 views1 answer
Restore backup "text" postgresql command line
SQL
33 votes169 views2 answers
Postgres how to add field created at
SQL
12 votes177 views2 answers
Insert multiple rows from another table sql
SQL
0 vote184 views1 answer
Mariadb select limit offset
SQL
8 votes170 views1 answer
How to remove tables from postgresql
SQL
0 vote279 views1 answer
Mysql update table from select on another table
SQL
0 vote198 views1 answer
USING THE NOT CONDITION IN SQL
SQL