Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag foreign keys Rss

   Items 1 to 6 of 6   
 

Drop and Re-Create All Foreign Key Constraints in SQL Server

Aaron Bertrand supplies a script which generates two separate sets of commands: one to drop all foreign key constraints, and one to create them again. These scripts are stored in a table so that, if you drop the constraints and then disaster of some kind strikes during the create, you still have everything handy and can troubleshoot if needed.  Read more...
By Additional Articles 2014/10/17 | Source: MSSQLTips.com | Category: foreign keys
Rating:  Rate this |   Briefcase | 7,704 reads

Questions about Primary and Foreign Keys You Were Too Shy to Ask

It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without feeling embarrassed, yet nobody likes to ask vital questions about SQL Server primary keys and foreign keys. Fear not, here are 13 questions you were too shy to ask, answered.  Read more...
By Additional Articles 2014/10/14 | Source: SimpleTalk | Category: primary keys
Rating: (not yet rated)  Rate this |   Briefcase | 8,805 reads

Running Out Of Foreign Keys

By Andy Warren 2014/05/20 | Category: foreign keys
Rating: (not yet rated) |  Discuss |   Briefcase | 1,698 reads

Find Foriegn Keys and their details in a database

Use this script to find all the Foriegn Keys and their details in a database  Read more...
By Bodhisatya Mookherjee 2013/09/11 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 1,346 reads

New SQL Monitor Custom Metric: Untrusted Foreign Keys

A foreign key points to a primary key that must exist in another table, for example, column X in Table 1 must also be present in Table 2. The key protects this link, and only valid data can be inserted in the foreign key column. An untrusted foreign key may threaten a database‚Äôs referential and data integrity.  Read more...
By Press Release 2013/08/20 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,191 reads

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.  Read more...
By Shaun J. Stuart 2013/06/17 | Source: SQLServerCentral.com | Category: foreign keys
Rating: |  Discuss |   Briefcase | 606 reads
   Items 1 to 6 of 6   
 
Tags
check constraints (1)    
custom metrics (1)    
primary keys (1)    
schema (1)    
sql monitor (1)