/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 vote121 views2 answers
Begin transaction sql
SQL
1 vote124 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
31 votes118 views4 answers
Mysql grant execute
SQL
2 votes152 views1 answer
Tsql copy table
SQL
2 votes123 views1 answer
How to create sql database
SQL
0 vote114 views3 answers
How to increase size of column in sql
SQL
2 votes184 views1 answer
Postgresql group by month and year
SQL
19 votes110 views6 answers
Sql drop table if exists
SQL
0 vote104 views1 answer
Use where instead of join
SQL
0 vote97 views1 answer
Faire une recherche par liste de mot clé sql
SQL

Share