/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 vote301 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
-1 vote287 views1 answer
Mysql extract days
SQL
5 votes279 views2 answers
Ranking functions in sql
SQL
0 vote282 views4 answers
Sql year
SQL
3 votes286 views1 answer
Oracle apex warning message
SQL
6 votes334 views2 answers
Mysql convert timestamp to date
SQL
3 votes312 views1 answer
Postgresql today - 1 year
SQL
1 vote293 views1 answer
How to install mysql 8.0 windows service
SQL
1 vote284 views1 answer
Oracle list constraints
SQL
0 vote277 views1 answer
Version and edition of SQL Server Database Engine
SQL

Share