/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

1 vote176 views4 answers
Sql now
SQL
2 votes200 views3 answers
Sql truncate table
SQL
11 votes224 views1 answer
Ddl view
SQL
0 vote196 views1 answer
Google sheets filter rows above current cell
SQL
0 vote263 views1 answer
Oracle current date minus 1 day
SQL
0 vote220 views1 answer
Sql quary stuf
SQL
0 vote180 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
0 vote261 views3 answers
How to find all role in mysql
SQL
0 vote208 views1 answer
Sql on-premises
SQL
1 vote181 views1 answer
How to delete data from sql database in android
SQL

Share