Stairway to Database Design STEP 2: Domains, Constraints and Defaults

Posted on SQL Server Central See other posts from SQL Server Central
Published on 2010/05/04 Indexed on 2010/05/04 6:10 UTC
Read the original article Hit count: 198

Filed under:
A clear understanding of SQL Data Types and domains is a fundamental requirement for the Database Developer, but it is not elementary. If you select the most appropriate data type, it can sidestep a variety of errors. Furthermore, if you then define the data domains as exactly as possible via constraints, you can catch a variety of those problems that would otherwise bedevil the work of the application programmer.

© SQL Server Central or respective owner