Sql

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

-- To change a column to nullable
ALTER TABLE mytable ALTER COLUMN mycolumn DROP NOT NULL;

PREVIOUS	NEXT

Code Example
Sql :: copy column data to another column sql with creating slugs
Sql :: create table if not exists postgresql
Sql :: search column name sql
Sql :: mysql count newlines in field
Sql :: mysql select table names
Sql :: get table column names sql ssms
Sql :: how to add unique constraint in mysql table
Sql :: How to fetch data in between startfromdate to starenddate in sql
Sql :: describe table mysql
Sql :: ms sql how to see active job current run time
Sql :: sql server 2012 query history
Sql :: how to check database size in mysql
Sql :: sql print all names that start with a given letter
Sql :: rails run native ssql query
Sql :: installing mysql on fedora
Sql :: pop sql insert value into
Sql :: postgres truncate with cascade
Sql :: set password mysql
Sql :: list all tables and columns in postgresql
Sql :: sql server pagination
Sql :: start mysql linux terminal
Sql :: sql primary key with multiple columns
Sql :: mysql copy table1 to table2
Sql :: laravel paginate raw sql
Sql :: oracle cannot access v$session
Sql :: mysql reset auto increment to 1
Sql :: import .sql into postgres db command
Sql :: oracle substring
Sql :: backup ms sql database table data to file
Sql :: grant all priviledges to mysql user