Re-Trust Untrusted Foreign Keys and Constraints
This script will attempt to re-trust untrusted foreign keys and will report counts of successes and failures.
2013-06-17 (first published: 2013-05-30)
1,120 reads
Foreign Keys (FK)
2013-04-24
2,060 reads
Rename Foreign Key Constraints
Rename Foreign Key Constraints in a consistent manner. Ideal for preventing constraint errors during code promotion.
2018-04-13 (first published: 2013-03-19)
1,340 reads
2012-10-23
2,154 reads
2012-10-12 (first published: 2012-09-10)
1,785 reads
2012-05-18
2,988 reads
2011-10-25
2,462 reads
Check if Constraint is enabled or disabled
This is a script to find all constraints and check if they are enabled or disabled.
2011-11-10 (first published: 2011-10-12)
6,784 reads
Holy Foreign Keys and Indexes
This article shows an interesting issue with foreign keys and how they are aligned with the base tables in SQL 2005 SP 4.
2011-10-10
5,754 reads
SQL Server Foreign Key Update and Delete Rules
Foreign key constraints are an integral part of SQL Server database design. These are used to maintain integrity among related data in different tables. While implementing update and delete operations on values in the parent table (referenced table with primary key) we have to consider the impact on related values in the child table. SQL Server provides different rules for managing the effect of updates and deletes on child table values. How can these rules be used effectively without threatening the relational integrity?
2011-05-03
4,940 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers