/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 vote348 views1 answer
Kill thread
SQL
-1 vote342 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
4 votes379 views2 answers
Oracle unlock account
SQL
0 vote357 views4 answers
Best data type to represent money in mysql
SQL
13 votes373 views2 answers
Sql online compiler
SQL
0 vote373 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
21 votes313 views7 answers
Table drop if exist sql server
SQL
0 vote355 views1 answer
How to change the field size of an existing column
SQL
0 vote359 views1 answer
Opensuse stop MySQL
SQL
0 vote338 views1 answer
Mysql delete from where like
SQL

Share