SQL教程 第9章 数据库完整性.pdfVIP

9 SQL Server UNIQUE PRIMARY KEY IDENTITY FOREIGN KEY CHECK DEFAULT NOT NULL FOREIGN KEY CHECK CREATE TABLE 9.1 SQL Server 2000 • PRIMARY KEY • FOREIGN KEY • UNIQUE • CHECK • NOT NULL() SQL Server 2000 NOT NULL 9.1.1 PRIMARY KEY PRIMARY KEY PRIMARY KEY • • PRIMARY KEY (PRIMARY KEY ) • PRIMARY KEY PRIMARY KEY PRIMARY 2 SQL Server 2000 KEY PRIMARY KEY NULL NULL 0 SQL test department dno USE test GO CREATE TABLE department /**/ ( dno int PRIMARY KEY, /*,*/ dname char(20), /**/ ) GO Transact-SQL PRIMARY KEY PRIMARY KEY SQL Server PK_ 9.1.2 FOREIGN KEY FOREIGN KEY FOREIGN KEY FOREIGN KEY • • FOREIGN KEY () PRIMARY KEY UNIQUE FOREIGN KEY FOREIGN KEY • FOREIGN KEY FOREIGN KEY FOREIGN KEY FOREIGN KEY USE test GO CREATE TABLE worker /**/ ( no int PRIMARY KEY, /*,*/ 9 3 name char(8), /**/ sex char(2), /**/ dno int /**/ FOREIGN KEY REFERENCES department(dno) ON DELETE NO ACTION, address char(30) /**/ ) GO (