Add NOT NULL constraint to large table without table scan
15054
Does PostgreSQL optimize adding columns with non-NULL DEFAULTs?
88678
Optimize table layout
26856
How do I specify unique constraint for multiple columns in MySQL?
141930
Implementing a "Both, Either-or, but Not Null" Requirement in a Database
88049
How to insert a column in a specific position in oracle without dropping and recreating the table?
82726
Foreign Key (references) constraint on PostgreSQL Foreign Data Wrapper?
148344
Can you prevent more than X number of rows being updated in SQL Server?
114718
Is there a DBMS that allows the "= NULL" syntax?
8161
How do I create a stored procedure that will optionally search columns?
100019
Why does a UNIQUE constraint allow only one NULL?
133977
Alter CONSTRAINT or stored procedure only to check when insert not on update
122246
SQL Server 2005 How Create a Unique Constraint?
91377
Add Auto-Increment ID to existing table?
141201
Simple CHECK Constraint not so simple
425
Normalize a MySQL table with more than 250 Boolean columns
68948
Alternative to a columns of checkboxes in a table
156181
How do completely empty columns in a large table affect performance?