/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 vote120 views2 answers
Script all indexes in a database
SQL
2 votes117 views1 answer
No data found oracle
SQL
1 vote124 views1 answer
Create email address from first and last name in sql
SQL
0 vote116 views1 answer
Mysql select where field like in list
SQL
0 vote116 views1 answer
How to put is null in where in clause
SQL
0 vote113 views1 answer
Mysqldump don't drop table
SQL
0 vote113 views1 answer
Mysql error 1452
SQL
0 vote119 views1 answer
How to use lower case in mysql
SQL
0 vote107 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
8 votes114 views2 answers
Mysql query dates between two dates
SQL

Share