Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 483 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

 

DB2 Basics: Constraints

Available for Members. This is an off-site link. Please review our Terms of Service (bottom of page) for additional information.  See Related Articles


 Article Abstract:

(Roman B. Melnyk) Constraints are used by DB2 UDB to enforce business rules for data and to help preserve database integrity. This article describes the various types of constraints supported by DB2 UDB and provides examples of each constraint type. In addition, the author explains the fundamentals of constraints management (using either the command line or the DB2 Control Center).

Constraints are used by DB2 Universal Database(DB2 UDB) to enforce business rules for data. This article describes the following types of constraints:

--NOT NULL
--Unique
--Primary key
--Foreign key
--Table check

 Read this article...
 Related Articles - For Members.
Second Normal Form (2NF)
SQL Server 6.5: Some useful undocumented DBCC commands
SQL Server 2000 useful undocumented stored procedures
Using Check Constraints to Simulate Domains
Meta Data User-Defined Functions
Automate Database Defragmentation and Statistics Updates
SQL Server 7.0 useful undocumented stored procedures
Rolling Window, Grouping Tables and More
Temporary Tables: Declared and Created
Split Comma Separated Data Into A Table



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004