/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 vote85 views1 answer
Update sql join multiple tables
SQL
0 vote164 views2 answers
Sql update multiple tables
SQL
0 vote120 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote133 views2 answers
Mysql multiply
SQL
0 vote144 views1 answer
Gcloud sql list databases
SQL
5 votes140 views1 answer
How to use rank function in sql
SQL
25 votes118 views1 answer
Mysql grant all privileges to a user
SQL
10 votes120 views4 answers
Primary key in sql
SQL
6 votes132 views2 answers
Can't connect to local mysql server through socket
SQL
10 votes142 views6 answers
Sql between
SQL

Share