/SQL/Create column sql

Create column sql

Sqlserver add column to table

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

16

Create column sql

ALTER TABLE table_name
ADD column_name datatype;

12

Sql server alter column

ALTER TABLE table_name 
ALTER COLUMN column_name new_data_type(size);

11

Source: sqlservertutorial.net

Append column sql

ALTER TABLE table_name
ADD column_name datatype;--exampleALTER TABLE CustomersADD Email varchar(255);

7

Similar codes

-1 vote187 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote188 views1 answer
Change data type in mysql
SQL
15 votes210 views6 answers
Laravel db transaction
SQL
7 votes191 views4 answers
Mysql delete older duplicates
SQL
1 vote198 views1 answer
How to update date add hours in postgresql
SQL
0 vote169 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
3 votes195 views2 answers
Sql paging query
SQL
0 vote205 views1 answer
How do you insert boolean to postgresql
SQL
0 vote185 views1 answer
Concatenate columns in table
SQL
0 vote193 views1 answer
Oracle running queries sql
SQL

Share