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

4 votes132 views2 answers
Delete all table oracle
SQL
0 vote83 views1 answer
Postgresql subquery
SQL
2 votes139 views1 answer
Capitalize 1st letter in sql server
SQL
15 votes207 views3 answers
Postgresql change column type
SQL
1 vote142 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote118 views1 answer
Dns slave zone convert
SQL
0 vote127 views1 answer
Enable full text search mysql
SQL
1 vote133 views1 answer
Does insert into overwrite sql
SQL
0 vote196 views1 answer
Site:av.ru "files"
SQL
-1 vote148 views5 answers
Operator in sql
SQL