约束有两种类型:表级约束和列约束。
Constraints come in two types: table-level constraints and column constraints.
换句话说,模式并不等同于sql列约束。
In other words, schemas are not the equivalent of SQL column constraints.
为列定义的所有默认约束必须相同。
Any default constraints defined for columns must be the same.
Checkconstraints视图—允许添加表及其列的检查约束。
Check constraints view a "Allows adding check constraints for a table and its columns."
有时候您希望更改这种顺序或可能希望只为具有NOT NULL约束的列指定值。
Sometimes you may want to change this order or perhaps only specify values for columns that have NOT NULL constraints.
这意味着表必须有一个或多个列级或表级约束。
This implies that the table must have one or more columns or table-level constraints.
在这种情况中,你把文档添加到模型的每一个元素中,包括每个列,每个表,每个约束和每个触发器。
In this activity, you add documentation to every element in the model, including every column, every table, every constraint, and every trigger.
尽量减少表上的触发器、检查和外键约束以及生成的列。
Minimize the triggers, CHECK and foreign key constraints, and generated columns for the table.
它们由逻辑数据模型转换而来,其中实体和关系转换为表、列、主键、外键以及约束。
They are transformations of logical data model where the entities and relationships are transformed into tables, columns, primary keys, foreign keys, and constraints.
用户可以使用检查约束来加强对xml列的验证。
A user can enforce validation on an XML column using check constraints.
在这个语法示例中,必须定义一个新列或者定义一个表级约束。
In this syntax example, you must either define a new column or define a new table-level constraint.
您可能理解列定义的含义,但是可能不理解约束的意义。
You probably understand what is meant by a column definition, but you might not understand the idea of a constraint.
请按清单7所示的顺序将字段添加到这个块(这些约束不影响列在表中的顺序—只影响在视图中的顺序)。
Add the fields to this block in the order shown in Listing 7. (These constraints don't affect the order of the columns in the table - just the view.)
接下来,在编辑器中选择新添加的外键约束,并使用Properties视图指定关键列。
Next, select the newly added foreign key constraint in the editor and specify the key columns using the Properties view.
现在,添加一个新约束,以便在将一个列设为privacydata时检查是否存在一个masking方法。
Now, follow these steps to add a new constraint to check for the existence of a masking method if a column is set as privacy data
表items和SUPPLIERS分别在列item_id和suppl_id上定义了检查约束。
Both tables ITEMS and SUPPLIERS have check constraints defined on columns item_id and suppl_id respectively.
我所能获取的列太多,又很容易遗漏重要的结构化数据库特性,比如索引或空约束。
I can fetch too many columns, or leave off important structural database features, like indexes or null constraints.
一种解决方法是给从BEFORE INSERT触发器取得值的NOT null列提供默认值,这样就不会违反约束。
A workaround to this is to supply a default value to the not NULL column whose value comes from a BEFORE INSERT TRIGGER, so that the constraint is not violated.
在XForms模型中,xfg生成xforms绑定属性形式的数据约束,它与数据库元数据相对应,比如列类型、长度、是否是必需的,等等。
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.
可以使用表设计器创建、编辑或删除表、列、键、索引、关系和约束。
You can use table Designer to create, edit, or delete tables, columns, keys, indexes, relationships, and constraints.
创建唯一约束可确保在不参与主键的特定列中不输入重复值。
Create a unique constraint to ensure no duplicate values are entered in specific columns that do not participate in a primary key.
与CHECK约束不同的是,dml触发器可以引用其他表中的列。
Unlike CHECK constraints, DML triggers can reference columns in other tables.
在服务器资源管理器、数据库关系图设计器或表设计器中选择应用该约束的列。
Select the column to which the constraint applies in Server Explorer, Database Diagram Designer, or Table Designer.
这可以采用添加列、更改列的数据类型、添加约束或者甚至删除列的方式来实现。
This can take the form of adding a column, changing the data type for a column, adding a constraint, or even deleting a column.
如果表的主键或惟一性约束中指定了这个列,那么不允许使用这个子句(SQLSTATE 42831)。
This clause is not allowed if the column is specified in the primary key, or in a unique constraint of the table (SQLSTATE 42831).
当两个相关列都是主键或都具有唯一约束时,将创建一对一关系。
A one-to-one relationship is created if both of the related columns are primary keys or have unique constraints.
利用这些规则,可以通过对无约束网络的不定导纳矩阵进行初等的行、列变换得到约束网络的导纳矩阵。
With the rules, the nodal admittance matrix can be obtained by simple row and column transformations in the unconstrained indefinite-admittance matrix.
当将唯一约束附加到允许空值的列时,请确保在约束的列中最多有一行包含空值。
When you attach a unique constraint to a column allowing null values, you ensure that at most one row will have a null value in the constrained column.
当想要更改约束所附加到的列、更改约束名称或设置约束的附加属性时,可修改唯一约束。
Modify a unique constraint when you want to change the columns that the constraint is attached to, change the constraint name, or set additional properties for the constraint.
数据违反了一列或多列的完整性约束。
The data violated the integrity constraints for one or more columns.
应用推荐