/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 vote153 views1 answer
SQLServerException.makeFromDatabaseError
SQL
2 votes193 views5 answers
Install postgresql 10 centos 7
SQL
0 vote145 views1 answer
Sqlite higher or equal
SQL
0 vote163 views1 answer
Table user postgres
SQL
3 votes167 views3 answers
Order by postgres
SQL
0 vote187 views1 answer
Generate sql from specific migration ef core
SQL
3 votes159 views3 answers
1396(hy00) mysql error
SQL
0 vote135 views1 answer
Psql datestyle
SQL
8 votes151 views1 answer
Check mysql version phpmyadmin
SQL
0 vote214 views1 answer
Mysql disable triggers
SQL

Share