UNIQUE constraint of Microsoft SQL Server and CHECK constraint of MySQL

Micsoft SQL Server allows only one null value for the column having UNIQUE constraint, as with any other(non-null) value. This is quiet different from Oracle.

MySQL provides CHECK contraint syntax in its SQL, but it doesn't really check the contraint in run-time, at leat as of version 5.0. The syntax is for compatibility of the SQL.


Post a Comment