/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

3 votes166 views1 answer
Oracle revoke
SQL
1 vote169 views3 answers
Postgresql crete view
SQL
0 vote177 views1 answer
Get primary key of table
SQL
0 vote166 views10 answers
John the ripper mysql
SQL
0 vote213 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote175 views1 answer
My sql data file extention
SQL
0 vote169 views1 answer
Sql_inner_join
SQL
13 votes183 views2 answers
Sql join 3 tables
SQL
0 vote173 views1 answer
Will graphql replace sql
SQL
3 votes232 views1 answer
Mysql cli connect with password
SQL

Share