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

Content with tag constraints Rss

   Items 1 to 20 of 27    Older >>
 

Code For Truncating Table with foreign Key Constraints

This can be used for data warehouses as well as truncating table with foreign key constraints.  Read more...
By Vimal Lohani 2014/08/06 | Source: SQLServerCentral.com | Category: truncating tables
Rating: |  Discuss |   Briefcase | 1,299 reads

T- SQL Constraints

By Shiva N (AxSys) 2014/07/31 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,772 reads

It's Not All About The Keys

By Andy Warren 2014/04/14 | Category: foreign key
Rating: (not yet rated) |  Discuss |   Briefcase | 2,056 reads

Leveraging Constraint Evaluation Sequence in SQL Server

Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.  Read more...
By Nakul Vachhrajani 2014/01/27 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 2,608 reads

Create Table

By Kapil Singh 2013/04/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,165 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

UNIQUE constraint

By Gopinath S 2012/12/20 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,009 reads

Handling Constraint Violations and Errors in SQL Server

The database developer can, of course, throw all errors back to the application developer to deal with, but this is neither kind nor necessary. How errors are dealt with is dependent on the application, but the process itself isn't entirely obvious.  Read more...
By Additional Articles 2012/07/10 | Source: SimpleTalk | Category: constraints
Rating: (not yet rated)  Rate this |   Briefcase | 3,083 reads

Constraints and the Test-Driven Database

Bad data always seems to appear when, and where, one least expects it. Sam explains the great value of a defensive approach based on constraints to any team that is developing an application in which the data has to be exactly right, and where bad data could cause consequential severe financial damage. It is perhaps better seen as creating a test-driven database.  Read more...
By Additional Articles 2012/01/09 | Source: SimpleTalk | Category: database design
Rating: (not yet rated)  Rate this |   Briefcase | 1,897 reads

Constraints

By Thomas Abraham 2011/10/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,580 reads

Primary Keys – why accept the defaults.

G’day, When I design a table in SQL SERVER, I like to have a reasonable understanding of how the table will...  Read more...
By Martin Catherall 2011/03/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,407 reads

Columns Explorer - With constraints create / drop scripts (no cursors)

Gets all columns infos, foreign keys (multicolumn fk handled), referenced primary keys, default and check constraints, indexes, Create/Drop scripts for all constraints.  Read more...
By antonio cuna 2011/02/28 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,479 reads

Fix Column Check Constraint Naming

This stored procedure can be used for applying a custom column check constraint naming convention  Read more...
By Michael Søndergaard 2010/10/12 | Source: SQLServerCentral.com | Category: constraints
Rating: |  Discuss |   Briefcase | 491 reads

Fix Foreign Key Constraint Naming

This stored procedure can be used for applying a custom foreign key constraint naming  Read more...
By Michael Søndergaard 2010/10/08 | Source: SQLServerCentral.com | Category: constraints
Rating: |  Discuss |   Briefcase | 1,269 reads

Fix Default Constraint Naming

This stored procedure can be used for applying a custom default constraint naming  Read more...
Rating: |  Discuss |   Briefcase | 289 reads

Fix Default Constraint Naming

This stored procedure can be used for applying a custom default constraint naming  Read more...
Rating: |  Discuss |   Briefcase | 546 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,413 reads

Tables

By SQL Buzz 2010/06/17 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 3,881 reads

How many Records Will Get Selected

By SQL Buzz 2010/06/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,676 reads

Declarative Data Integrity

By bitbucket-25253 2010/01/25 | Category: foreign keys (fk)
Rating: (not yet rated) |  Discuss |   Briefcase | 3,878 reads
   Items 1 to 20 of 27    Older >>
 
Tags
t-sql (7)    
foreign keys (fk) (6)    
change constraint name (4)    
naming convention (4)    
database design (3)    
default constraints (2)    
indexing (2)    
administration (1)    
blob manipulation (1)    
blogs (1)    
check constraints (1)    
ddl (1)    
dri (1)    
foreign key (1)    
insert (1)    
is system named (1)    
null (1)    
primary key (pk) (1)    
referential integrity (1)    
select (1)    
sql server (1)    
table (1)    
triggers (1)    
truncating table with foreign key constraints (1)    
truncating tables (1)