Here are some additional changes in SQL Server 2016.
| Feature | SQL 2014 | SQL 2016 |
|---|---|---|
| Foreign Keys | Not supported | Supported |
| Check/Unique Constraints | Not supported | Supported |
| Parallelism | Not supported | Supported |
| Indexes on NULLable columns | Not supported | Supported |
| Maximum size of durable table | 256 GB | 2 TB |
| ALTER PROCEDURE / sp_recompile | Not supported | Supported |
| SSMS Table Designer | Not supported | Supported |
| Check/Unique Constraints | Not supported | Supported |
