Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Primary key Rss

   Items 1 to 8 of 8   
 

Auto-suggesting foreign keys and data model archaeology

If you can understand the data model then you can understand the intent of the application developers.  Read more...
By David Poole 2016/01/26 | Source: SQLServerCentral.com | Category: foreign key
Rating: |  Discuss |   Briefcase | 2,508 reads

Deciding on a Primary Key in Oracle

Designing a system with primary keys in mind is not an easy task, and the solutions may not be the simplest. However the effort is well worth the time and trouble when you realize that it's the best way to prevent duplicate data - but how do you choose a primary key? David Fitzjarrell looks at several examples.  Read more...
By Additional Articles 2015/08/25 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 3,933 reads

List Table Foreign Keys, Primary key and indexes

This procedure let you list [optional] by table: -Foreign keys -Primary key -Indexes   Read more...
By Martin Collazos 2015/03/27 | Source: SQLServerCentral.com | Category: foreign key list
Rating: |  Discuss |   Briefcase | 3,839 reads

List Table Foreign Keys, Primary key and indexes

This procedure let you list [optional] by table: -Foreign keys -Primary key -Indexes   Read more...
By Martin Collazos 2015/03/27 | Source: SQLServerCentral.com | Category: foreign key list
Rating: |  Discuss |   Briefcase | 3,839 reads

Why Primary Keys can be important on large tables

I inherited a database that was getting large and not performing well. After adding primary keys life got better.  Read more...
By Ben Kubicek 2014/06/30 | Source: SQLServerCentral.com | Category: primary key
Rating: |  Discuss |   Briefcase | 11,942 reads

List Table Foreign Keys, Primary key and indexes

This procedure let you list [optional] by table: -Foreign keys -Primary key -Indexes   Read more...
By Martin Collazos 2015/03/27 | Source: SQLServerCentral.com | Category: foreign key list
Rating: |  Discuss |   Briefcase | 3,839 reads

Primary Key Primer for SQL Server

Every database developer uses keys, but without always understanding all the ramifications. They come with few hard and fast rules, but if you get them right from the start with a database design, the whole process of database development is simpler, and the result is likely to perform better. We asked Phil for advice, little knowing that the explanation might take a while.  Read more...
By Additional Articles 2013/12/19 | Source: SimpleTalk | Category: primary key
Rating: (not yet rated)  Rate this |   Briefcase | 4,428 reads

BIT Primary Key

By Thomas Kovarik 2013/01/29 | Category: primary key
Rating: (not yet rated) |  Discuss |   Briefcase | 2,528 reads
   Items 1 to 8 of 8   
 
Tags
foreign key (2)    
clustered index (1)    
fk (1)    
foreign key list (1)    
heap table (1)    
indexing (1)    
introduction (1)    
oracle (1)    
pk (1)    
system tables (1)    
t-sql (1)