/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 votes311 views3 answers
Raw select laravel
SQL
1 vote274 views1 answer
Get url of cpanel database hostname
SQL
0 vote283 views1 answer
Modificar tipo de dato sql server
SQL
1 vote269 views2 answers
Pl sql case
SQL
5 votes297 views1 answer
Oracle sysdate - 1 month
SQL
3 votes282 views3 answers
Your password does not satisfy the current policy requirements
SQL
1 vote307 views2 answers
Maximum number of tables in mysql
SQL
4 votes272 views1 answer
To date oracle with time
SQL
-1 vote289 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote297 views2 answers
Advantages of stored procedures sql
SQL

Share