Sql

ALTER TABLE table_name
ALTER COLUMN column_name datatype;

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

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

ALTER TABLE Names
MODIFY number float;

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

alter table my_table alter column my_column int null

PREVIOUS	NEXT

Code Example
Sql :: how to create a table structure from another table in mysql
Sql :: eliminar ultimo carcacter mysql
Sql :: sql alchemy or
Sql :: delete from IN subquery
Sql :: sql primary key syntax
Sql :: oracle sql sort ascending
Sql :: postgres left join
Sql :: sql server default port
Sql :: postgres create database if not exists
Sql :: default value false mysql
Sql :: creating sqeuence in oracle database
Sql :: postgres windows import dump
Sql :: using SQL in rails migration
Sql :: oracle create package body
Sql :: Write an SQL query to fetch worker names with salaries = 50000 and <= 100000.
Sql :: sql latlng
Sql :: create a PostgreSQL user django on mac
Sql :: mysql add hours to time field
Sql :: right join sql
Sql :: insert into sql
Sql :: bigquery timestamp
Sql :: mysql delete from where like
Sql :: setval in postgres
Sql :: not between mysql
Sql :: sql set data from a select query to a temp table and insert
Sql :: sql query to return field name of a table
Sql :: divide by zero error in sql
Sql :: mysql date_format
Sql :: sql table creation
Sql :: if sql