/SQL/SQL Server change column data type

SQL Server change column data type

Sql change column types

ALTER TABLE table_name
ALTER COLUMN column_name datatype;

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

20

Sql server alter column

ALTER TABLE table_name 
ALTER COLUMN column_name new_data_type(size);

12

Source: sqlservertutorial.net

SQL Server change column data type

alter table my_table alter column my_column int null

-1

Source: dba.stackexchange.com

Similar codes

0 vote304 views1 answer
Mysql update privileges
SQL
1 vote290 views1 answer
Postgresql update auto_increment value
SQL
0 vote320 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote319 views1 answer
Search column name sql
SQL
0 vote270 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
1 vote308 views1 answer
Sql server 2016 reseed identity
SQL
1 vote314 views1 answer
Get last week data in mysql
SQL
0 vote299 views1 answer
How to count with except in psql
SQL
0 vote300 views1 answer
Database springboot
SQL
0 vote338 views2 answers
Sql day from datetime
SQL

Share