/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

2 votes165 views1 answer
Python sql
SQL
1 vote125 views1 answer
How to delete data from sql database in android
SQL
10 votes213 views2 answers
Doublon sql
SQL
0 vote133 views1 answer
SQL loop with cursor
SQL
14 votes152 views3 answers
Oracle sql limit results
SQL
0 vote138 views1 answer
Stored procedure function relation
SQL
-1 vote136 views1 answer
Sql add column bit
SQL
4 votes133 views2 answers
How to count items with same name in sql
SQL
22 votes164 views3 answers
Sql cheat sheet
SQL
0 vote142 views1 answer
Resullt all update knex mysql
SQL

Share