Microsoft® SQL Server 2012 Unleashed

What’s New in Data Integrity

Much of the functionality related to data integrity has remained the same in SQL Server 2012. Several features that were added in SQL Server 2005, such as cascading integrity constraints, are still supported in SQL Server 2012. The lack of change in this area is generally a blessing. The tools available to enforce data integrity were comprehensive in 2005 and remain so in 2012.

Keep in mind that bound defaults, which were deprecated in SQL Server 2005, are still available in SQL Server 2012. For now, you can still use this statement to create a default that is bound to one or more columns. Microsoft recommends using the DEFAULT keyword with ALTER TABLE or CREATE TABLE instead.