Sql coding for beginners: An essential tool for developers using SQL statements for controlling and modifying tables, and an intermediate-level guide for learning SQL programming step by step by Coding Tony

Sql coding for beginners: An essential tool for developers using SQL statements for controlling and modifying tables, and an intermediate-level guide for learning SQL programming step by step by Coding Tony

Author:Coding, Tony [Coding, Tony]
Language: eng
Format: epub
Published: 2020-09-09T16:00:00+00:00


Define CHECK Constraints

Earlier in the chapter, in the “Understand Integrity Constraints” section, I discussed the various constraint categories and the types of constraints they support. (Refer back to Figure 4-1 for an overview of these categories.) One type of constraint—, the CHECK constraint, —can be defined as table constraints, column constraints, domain constraints, or within assertions. A CHECK constraint allows you to specify what values can be included in a column. You can define a range of values (for example, between 10 and 100), a list of values (for example, blues, jazz, pop, country), or a number of other conditions that restrict exactly what values are permitted in a column.



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.