/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 votes331 views4 answers
Stop MySQL
SQL
0 vote334 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote375 views1 answer
Psql create usr
SQL
3 votes310 views1 answer
How to check schema privileges in oracle
SQL
1 vote301 views1 answer
Mysql select utc time in eastern time
SQL
1 vote338 views3 answers
How to truncate table with foreign key constraint
SQL
9 votes324 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
3 votes315 views3 answers
How to set up an auto incrementing id db browser
SQL
1 vote351 views1 answer
Sqlite update from another table
SQL
1 vote314 views1 answer
Postgres format date in select
SQL

Share