/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

6 votes377 views2 answers
Sql sequence
SQL
0 vote377 views1 answer
Insert into table with only identity column
SQL
3 votes345 views1 answer
Oracle apex warning message
SQL
0 vote378 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote340 views1 answer
View acl table oracle
SQL
25 votes386 views6 answers
How to change column name in mysql
SQL
1 vote355 views1 answer
Oracle sql pad left zeros
SQL
0 vote342 views1 answer
Sql last 7 days
SQL
1 vote368 views7 answers
Filter
SQL
0 vote336 views1 answer
Raiserror nowait sql server
SQL

Share