/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 vote262 views1 answer
Calculate discount from original price sql
SQL
0 vote309 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote308 views1 answer
Linebreak sql
SQL
0 vote306 views1 answer
Sql create text column limited values
SQL
1 vote308 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote306 views1 answer
Alter database name script
SQL
0 vote291 views1 answer
Sqlserver now
SQL
3 votes324 views1 answer
Sql insert inserted id
SQL
1 vote352 views1 answer
How to set up a trigger in sql
SQL
1 vote289 views1 answer
Postgres get timestamp
SQL

Share