/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 vote374 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote373 views1 answer
Reona
SQL
4 votes399 views1 answer
What are the data types
SQL
-2 votes354 views3 answers
Sqlite reset autoincrement
SQL
0 vote388 views2 answers
Mysql missin expression near on
SQL
0 vote315 views8 answers
Convert sql query to linq online
SQL
0 vote428 views1 answer
Generate sql from specific migration ef core
SQL
1 vote365 views1 answer
Mysql data from file
SQL
0 vote382 views1 answer
Adding primery key constraint to a column
SQL
15 votes354 views4 answers
T-sql drop function if exists
SQL

Share