Change column data type sql

Sql change column types

ALTER TABLE table_name
ALTER COLUMN column_name datatype;

-- Example
ALTER TABLE product
ALTER COLUMN description VARCHAR(250);

Sql server alter column

ALTER TABLE table_name 
ALTER COLUMN column_name new_data_type(size);

Source: sqlservertutorial.net

Sql alter type of column

ALTER TABLE TableName
MODIFY COLUMN ColumnName DataType;

Source: stackoverflow.com

T-SQL Alter the column data type

ALTER TABLE dbo.MyTable ALTER COLUMN MyColumn VARCHAR(20) NOT NULL;

Source: stackoverflow.com

Change column data type sql

ALTER TABLE TableName 
ALTER COLUMN ColumnName NVARCHAR(200) [NULL | NOT NULL]

Source: stackoverflow.com

Alter column type

ALTER TABLE schema.table
    ALTER COLUMN column
    DROP DEFAULT;
ALTER TABLE schema.table
    ALTER COLUMN column TYPE INTEGER[]
    USING array[column]::INTEGER[];
ALTER TABLE schema.table
    ALTER COLUMN column SET DEFAULT '{}';

Source: stackoverflow.com

Similar codes

0 vote248 views1 answer
Codeigniter 3 get best-selling products
SQL
18 votes232 views6 answers
Drop table if exists
SQL
1 vote225 views1 answer
SQL server query column yes or no
SQL
14 votes265 views3 answers
How to add default constraint in mysql
SQL
24 votes224 views5 answers
Sql reset auto increment
SQL
1 vote263 views1 answer
Mysql login console
SQL
0 vote229 views1 answer
Sql insert tuple
SQL
0 vote239 views1 answer
Postgresql check total storage
SQL
0 vote240 views1 answer
How convert into in in sql query
SQL
0 vote260 views1 answer
Oracle session statistics
SQL