在SQL Server 2005中识别系统数据库.ppt

You can summarize the session by running through the summary given in SG. In addition, you can also ask students summarize what they have learnt in this session. 例子： Stu_test表中添加一列cardno，唯一约束 默认约束： 默认约束可以用于指定一个常量值到列。 语法： CREATE TABLE table_name ( col_name [CONSTRAINT constraint_name] DEFAULT (constant_expression | NULL) (col_name [, col_name [, …]]) . ) 让我们看看如何… 实现数据完整性（续） employeeleave表的leavetype字段取值默认为pl 课间思考 哪个关键字被用于指定检查约束? 答案： 检查约束可以使用LIKE、 IN和BETWEEN关键字类指定。 Entity integrity is implemented using the PRIMARY KEY constraint. Referential integrity is implemented using the FOREIGN KEY and