/SQL/Sql server alter column

Sql server alter column

Sql change column types

ALTER TABLE table_name
ALTER COLUMN column_name datatype;

-- Example
ALTER TABLE product
ALTER COLUMN description VARCHAR(250);

20

Sqlserver add column to table

ALTER TABLE dbo.doc_exa 
ADD column_b VARCHAR(20) NULL, 
	column_c INT NULL ;

16

Sql server alter column

ALTER TABLE table_name 
ALTER COLUMN column_name new_data_type(size);

12

Source: sqlservertutorial.net

Modify column name in sql

ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);

3

Alter table query sql server change column

ALTER TABLE employees
  ALTER COLUMN last_name VARCHAR(75) NOT NULL;

1

Source: techonthenet.com

Change column data type sql

ALTER TABLE TableName 
ALTER COLUMN ColumnName NVARCHAR(200) [NULL | NOT NULL]

1

Source: stackoverflow.com

Similar codes

20 votes182 views2 answers
Mysql bigint max value
SQL
11 votes184 views2 answers
MySQL DISTINCT
SQL
0 vote253 views1 answer
Oracle create package specification
SQL
4 votes189 views2 answers
How to insert ip address in mysql using php
SQL
16 votes181 views4 answers
Ascending order mysql
SQL
35 votes194 views6 answers
Postgres
SQL
14 votes187 views2 answers
Oracle export trigger ddl
SQL
0 vote234 views1 answer
A network or instance-specific error sql server
SQL
0 vote224 views1 answer
Concat column value of same user in mysql
SQL
0 vote178 views1 answer
Mysql repair a table
SQL

Share