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 :: T-SQL - Delete Column
Sql :: 11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
Sql :: sql period overlap
Sql :: postgresql parse json array
Sql :: sql server remove primary key without dropping table
Sql :: mysql change value
Sql :: mysql function variable
Sql :: dba_dependencies
Sql :: drop schema sql
Sql :: how to delete a table in mysql
Sql :: sql if example
Sql :: sql query to find percentage of null values in a table
Sql :: between keyword in sql
Sql :: creating table in sql
Sql :: snowflake select from stage
Sql :: to_char sql
Sql :: create table with timestamp postgresql
Sql :: postgresql linux password
Sql :: mysql case when in select
Sql :: where condition in mongodb
Sql :: there is no unique constraint matching given keys for referenced table
Sql :: postgres sum when
Sql :: SQLITE_BUSY: database is locked
Sql :: declare or use variable in snowflake
Sql :: oracle create package body
Sql :: how to define a save method in ruby for sqlite3 databases
Sql :: mysql datetime format
Sql :: sql datum formatieren
Sql :: how to use timestampdiff in a table in sql
Sql :: mysql into outfile with headers