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

Content with tags Indexing, constraints Rss

   Items 1 to 3 of 3   
 

Find botched constraints, idxs, fks

Shows awesome view of columns with constraints and indexes and foreign keys to spot errors fast.  Read more...
By William Talada 2010/08/04 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |   Briefcase | 1,420 reads

Find botched constraints, idxs, fks

Shows awesome view of columns with constraints and indexes and foreign keys to spot errors fast.  Read more...
By William Talada 2010/08/04 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |   Briefcase | 1,420 reads

Should I Use a UNIQUE Constraint or a Unique Index in SQL Server?

I am modifying a table and I need to add a column that must be defined as being unique. I see that SQL Server allows you to define a UNIQUE constraint on a column but I also see that you can create a unique index on a column. Which one should I use?  Read more...
By Additional Articles 2008/09/05 | Source: MSSQLTips.com | Category: constraints
Rating:  Rate this |   Briefcase | 7,607 reads
   Items 1 to 3 of 3   
 
Tags
foreign keys (fk) (1)    
table (1)