/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 vote112 views2 answers
Foreign key set 0
SQL
0 vote93 views1 answer
Drop all tables in azure sql database
SQL
0 vote118 views1 answer
Make parameters nullable in sql server
SQL
15 votes111 views6 answers
Laravel db transaction
SQL
0 vote116 views1 answer
Mysql custom sort order
SQL
1 vote106 views1 answer
Oracle duration between timestamps
SQL
0 vote113 views1 answer
Sql check if column exists
SQL
0 vote96 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote107 views1 answer
SQL isnumeric DB2
SQL
0 vote108 views1 answer
Sqlalchemy.exc.OperationalError:
SQL

Share