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

0 vote519 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote341 views1 answer
Where date major today mysql
SQL
0 vote321 views1 answer
Search In the Data using ObjectName
SQL
0 vote313 views1 answer
Oracle index hint
SQL
3 votes334 views2 answers
Postgres show table schema
SQL
0 vote319 views1 answer
Laravel eloquent get generated sql
SQL
1 vote340 views1 answer
Name of today sql
SQL
3 votes339 views2 answers
Postgres download
SQL
0 vote355 views1 answer
Mysql faster delete
SQL
0 vote326 views1 answer
Mysql query problems and solutions
SQL