/SQL/Sql alter type of column

Sql alter type of column

Sql change column types

ALTER TABLE table_name
ALTER COLUMN column_name datatype;

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

20

Sqlserver add column to table

ALTER TABLE dbo.doc_exa 
ADD column_b VARCHAR(20) NULL, 
	column_c INT NULL ;

16

Sql server alter column

ALTER TABLE table_name 
ALTER COLUMN column_name new_data_type(size);

12

Source: sqlservertutorial.net

Sql alter type of column

ALTER TABLE TableName
MODIFY COLUMN ColumnName DataType;

2

Source: stackoverflow.com

Similar codes

0 vote277 views1 answer
Show function mysql
SQL
0 vote308 views1 answer
Mysql where in maintain order
SQL
1 vote291 views1 answer
Xampp import sql file command line
SQL
0 vote277 views1 answer
Select password from user mysql
SQL
0 vote289 views2 answers
How to update the multiple rows in sql
SQL
2 votes278 views1 answer
Mysql select random id from table
SQL
0 vote305 views1 answer
Postgres select from values
SQL
0 vote300 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote299 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote316 views1 answer
Migration graphql
SQL

Share