/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 vote198 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote197 views3 answers
ChAnge TABLE name apex oracle
SQL
1 vote275 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
9 votes214 views5 answers
Laravel to sql
SQL
-1 vote200 views1 answer
Ssql to lowercqse
SQL
0 vote190 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
7 votes225 views3 answers
Restore postgres database from sql file
SQL
1 vote186 views3 answers
Grant syntax in sql
SQL
0 vote187 views1 answer
Sql clear table
SQL
0 vote238 views1 answer
Change mysql version to 5.7 in ubuntu
SQL

Share