/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 vote220 views2 answers
Sqlite unix timestamp
SQL
0 vote222 views1 answer
Migrations.RunSQL
SQL
2 votes208 views1 answer
Anonymous block plsql
SQL
0 vote215 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote224 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
1 vote204 views1 answer
Sql only five first row
SQL
9 votes211 views2 answers
Get first 3 letters in sql
SQL
0 vote232 views1 answer
Radius search with point data in mysql
SQL
4 votes212 views3 answers
Mysql varchar length
SQL
2 votes220 views2 answers
Postgresql search all tables for column name
SQL

Share