Sqlserver add column

Sqlserver add column to table

ALTER TABLE dbo.doc_exa 
ADD column_b VARCHAR(20) NULL, 
	column_c INT NULL ;

Alter table add column

ALTER TABLE table_name 
ADD column_name datatype;

Sqlserver add column

ALTER TABLE myTable ADD newColumn bit NOT NULL default(0)

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 votes287 views4 answers
Show databases in sql server
SQL
0 vote277 views1 answer
Why mysql is used?
SQL
0 vote300 views1 answer
Get schema of table sql
SQL
0 vote300 views2 answers
Functions with parameters SQL
SQL
8 votes273 views1 answer
Alter tablespace add datafile
SQL
1 vote279 views1 answer
Postgresql last element of array
SQL
0 vote270 views1 answer
If null don't update
SQL
0 vote357 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
5 votes294 views1 answer
Sql select ciunt
SQL
0 vote297 views1 answer
Resullt all update knex mysql
SQL