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

1 vote161 views3 answers
How to truncate table with foreign key constraint
SQL
3 votes174 views2 answers
Mysql time
SQL
2 votes187 views2 answers
Sql lag
SQL
27 votes181 views6 answers
Sql update record
SQL
0 vote181 views1 answer
Can you write relational algebra into sql queries
SQL
17 votes179 views6 answers
Get last record in sql
SQL
18 votes162 views3 answers
Mysql query add column with default string value
SQL
0 vote176 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote176 views1 answer
How to check the port of mysql installation in mac
SQL
1 vote153 views2 answers
Difference between in and between in sql
SQL