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

Content with tag Foreign Keys (FK) Rss

   Items 1 to 20 of 46    Older >>
 

Ordered Loading of Databases Tables Using SSIS

Finding the load order for inserting data into a that respects referential integrity is sometimes difficult. If you are using SSIS, the task is made easier.  Read more...
Rating: |  Discuss |   Briefcase | 4,434 reads

Create Table

By Kapil Singh 2013/04/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,164 reads

A Check and Foreign Key Constraint Improves Query Performance

Check and foreign key constraint do not degrade performance but actually improve it.  Read more...
By Sarvesh Singh 2013/04/26 (first published: 2010/10/21) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 23,124 reads

FK to IDENTITY

By Nenad Zivkovic 2013/04/24 | Category: foreign keys (fk)
Rating: (not yet rated) |  Discuss |   Briefcase | 1,968 reads

Check Candidate Columns for FOREIGN KEY Constraints

Reports table columns that are not foreign keys but that perhaps should be.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 823 reads

Rename Foreign Key Constraints

Rename Foreign Key Constraints in a consistent manner. Ideal for preventing constraint errors during code promotion.  Read more...
By Wes Henriksen 2013/04/08 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 706 reads

An Introduction to Database Design

An introduction to database design for those people that might not understand what is involved.  Read more...
By Paul White 2013/01/11 (first published: 2011/01/18) | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 24,963 reads

Duplicate Foreign Key

By Lokesh Vij 2012/10/23 | Category: foreign keys (fk)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,049 reads

Find Foreign Keys

Lists the foreign keys between tables in the datavase,  Read more...
By suba sathyanathan 2012/10/12 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,663 reads

Drop FK For A Specific Table

Drop FK For A Sprecific Table  Read more...
By Danilo Antunez 2012/09/04 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,093 reads

Using DELETE CASCADE Option for Foreign Keys

Referential integrity is a very important thing to consider when designing a database. In my years as a DBA I've seen database designs that sit on both ends of the spectrum, none at all and cases where every table is linked to multiple tables. While the later certainly can be a little more difficult to work with it ensures the integrity of your data stays intact. The other end provides much more flexibility when it comes to updating and deleting data from your database, whether it's being done through the application or directly on the backend, but has the issue of possible orphan records if things are not done properly. This tip will look at the DELETE CASCADE option when creating foreign key constraints and how it helps keep the referential integrity of your database intact.  Read more...
By Additional Articles 2012/08/13 | Source: MSSQLTips.com | Category: t-sql
Rating:  Rate this |   Briefcase | 3,102 reads

Foreign key

By Igor Micev 2012/05/18 | Category: foreign keys (fk)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,925 reads

Foreign key

By Igor Micev 2012/04/06 | Category: database design
Rating: (not yet rated) |  Discuss |   Briefcase | 2,584 reads

Check if Constraint is enabled or disabled

This is a script to find all constraints and check if they are enabled or disabled.  Read more...
By roberto armellin 2011/11/03 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 935 reads

Violating Foreign Keys

By Chris Fradenburg 2011/10/25 | Category: foreign keys (fk)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,398 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.  Read more...
By James DiMauro 2011/10/10 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 5,344 reads

1NF View Generator

Creates a view/select statement for given transactional table using foreign key info. Great for ETL extraction or History table routine.  Read more...
By Mark Stockwell 2011/06/27 | Source: SQLServerCentral.com | Category: first normal form
Rating: |  Discuss |   Briefcase | 1,656 reads

Truncate All Tables Part 2

Restore relationships between tables  Read more...
By Jorge Novo-@ETLDEVDBA 2011/06/03 | Source: SQLServerCentral.com | Category: truncate table
Rating: (not yet rated) |  Discuss |   Briefcase | 977 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?  Read more...
By Additional Articles 2011/05/03 | Source: MSSQLTips.com | Category: foreign keys (fk)
Rating:  Rate this |   Briefcase | 4,110 reads
   Items 1 to 20 of 46    Older >>
 
Tags
t-sql (10)    
constraints (6)    
database design (5)    
indexing (4)    
primary key (pk) (4)    
administration (3)    
performance tuning (3)    
truncate table (3)    
cascade deletes (2)    
metadata (2)    
naming convention (2)    
sql server 2005 (2)    
table (2)    
utility (2)    
video (2)    
change constraint name (1)    
change foreign key name (1)    
check constraint (1)    
create (1)    
deadlock (1)    
delete (1)    
delete records (1)    
denormalization (1)    
dri (1)    
drop (1)    
drop table (1)    
etl extraction (1)    
execute (1)    
first normal form (1)    
history table (1)    
identity column (1)    
integration services (ssis) (1)    
is system named (1)    
lookups (1)    
maintenance (1)    
maintenance and management (1)    
miscellaneous (1)    
precedence constraints (1)    
referenced tables (1)    
referential integrity (1)    
relationship (1)    
search (1)    
sql server (1)    
tables (1)    
transactions (1)    
unique (1)    
xml (1)