SQL Server Constraints Tips
Data
- Avoid Untrusted Constraints in SQL Server
- Enforcing business rules using SQL Server CHECK constraints
- Finding and fixing SQL Server database constraint issues
- Should I Use a UNIQUE Constraint or a Unique Index in SQL Server?
- Truncate all tables in a SQL Server database
- Working with DEFAULT constraints in SQL Server
Foreign Keys
- Disable, enable, drop and recreate SQL Server Foreign Keys
- Drop and Re-Create All Foreign Key Constraints in SQL Server
- Find Violating SQL Server Foreign Key Values
- Foreign Key vs. Trigger Referential Integrity in SQL Server
- How to create a SQL Server foreign key
- Identify all of your foreign keys in a SQL Server database
- List Dependencies for SQL Server Foreign Keys
- Script to Delete Data from SQL Server Tables with Foreign Key Constraints
- SQL Server Foreign Key Update and Delete Rules
- SQL Server Referential Integrity without Foreign Keys
- The Importance of SQL Server Foreign Keys
Primary Keys
Scripting