/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

3 votes223 views3 answers
Update con select postgresql
SQL
2 votes217 views3 answers
Current setting postgres timezone
SQL
13 votes195 views2 answers
Sqlite rename column
SQL
1 vote200 views3 answers
Mysql disable foreign keys check
SQL
-1 vote217 views4 answers
Postgres between dates
SQL
4 votes219 views2 answers
Truncate oracle
SQL
0 vote198 views1 answer
Sql query for displaying age from oldest to youngest
SQL
-1 vote198 views1 answer
Window functions in sql
SQL
2 votes198 views1 answer
Pandas to sql index
SQL
10 votes220 views4 answers
Primary key in sql
SQL

Share