In other words, schemas are not the equivalent of SQL column constraints.
换句话说,模式并不等同于sql列约束。
Constraints come in two types: table-level constraints and column constraints.
约束有两种类型:表级约束和列约束。
This new validation will enforce NOT null column constraints by rejecting null values, but only in situations where your database would reject a null value.
这种校验会通过拒绝空值,强迫加上非空[notNULL]字段的约束,但是也只有在这种情况下,你的数据库会拒绝空值。
Generally, even if you wish to apply constraints in the loose way discussed in the last installment of this column, you should have a schema of some sort, for documentation if nothing else.
通常,即使您希望以松散的方式应用在本专栏上一篇文章中讨论过的约束,您也应该有某种模式供文档使用(如果不用于其它东西的话)。
A user can enforce validation on an XML column using check constraints.
用户可以使用检查约束来加强对xml列的验证。
In the XForms model, XFG generated data constraints as XForms bind attributes which correspond to database metadata, such as column type, length, required, and so on.
在XForms模型中,xfg生成xforms绑定属性形式的数据约束,它与数据库元数据相对应,比如列类型、长度、是否是必需的,等等。
If informational check constraints exist on the primary key column, you should explicitly specify informational check constraints on their corresponding foreign key columns. For example.
如果在主键列上存在信息检查约束,那么应该在它们相应的外键列上指定信息检查约束。
In most cases, constraints, indexes, and statistics defined on the column are also removed.
在多数情况下,列上的约束,索引,和统计信息也被移除。
It is not possible to rename a column, remove a column, or add or remove constraints from a table.
而重命名一个字段名和删除一个字段、或者增加和删除系统规定的参数这些操作是不可能的。
It is not possible to rename a column, remove a column, or add or remove constraints from a table.
而重命名一个字段名和删除一个字段、或者增加和删除系统规定的参数这些操作是不可能的。
应用推荐