/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

0 vote302 views1 answer
Excute raw query
SQL
0 vote307 views1 answer
Php get closest location by latitude longitude
SQL
0 vote311 views5 answers
Sql table intermédiaire
SQL
0 vote321 views1 answer
Mysql récupérer le code création de vue
SQL
1 vote299 views1 answer
Sql Split string function
SQL
0 vote308 views1 answer
Mysql cast null to string
SQL
0 vote358 views1 answer
Sql server query all database objects
SQL
3 votes302 views2 answers
Oracle apex view logs
SQL
0 vote311 views1 answer
Sql count total by foreign key
SQL
9 votes287 views4 answers
Mysql show table fields
SQL

Share