Sql

-- To change a column to NOT NULL:
ALTER TABLE products ALTER COLUMN product_no SET NOT NULL;

ALTER TABLE person ALTER COLUMN phone DROP NOT NULL;

ALTER TABLE table_name ALTER COLUMN column_name DROP NOT NULL;

PREVIOUS	NEXT

Code Example
Sql :: postgresql delete all content
Sql :: how to delete database in mysql
Sql :: sql order by number not ordered
Sql :: new uniqueidentifier in sql
Sql :: duplicate record mysql
Sql :: declare temp table in sql
Sql :: sql roll up rows into columns
Sql :: postgresql create table many-to-many
Sql :: how to select all fieldsin a soql query
Sql :: union vs union all in sql
Sql :: postgresql where and
Sql :: create db table
Sql :: order by number of character in sql
Sql :: mariadb create index if not exists
Sql :: how to get column name in db from an sqlalchemy attribute model
Sql :: fk in insert mysql
Sql :: sql check if table exists
Sql :: having in sql server
Sql :: sql exemplos
Sql :: isnull in sqlite
Sql :: minus equivalent in my sql
Sql :: sql numeric data type
Sql :: sql select like
Sql :: openquery join two tables
Sql :: oracle boolean to varchar
Sql :: remove decimal in sql server
Sql :: how to show current database in mysql
Sql :: select query in mongodb
Sql :: SQL Syntax of FULL OUTER JOIN
Sql :: how to insert same table data using mysql query