3.数据库设计步骤 CREATE TABLE Tablel COL O VARCHAR (20) NOT NULL, COL I NUMERIC(5) NOT NULL CONSTRAINT PK Table10 PRIMARY KEY NONCLUSTERED(COL 0) GO CREATE TABLE Table2 COL 2 VARCHAR (10)NOT NULL COL 3 VARCHAR(20)NOT NULL, COL 4 VARCHAR ( 10) NOT NULL UNIQUE, COL O VARCHAR(20), CONSTRAINT PK Table21 PRIMARY KEY NONCLUSTERED(COL 2) Go ALTER TABLE Table2 ADD CONSTRAINT FK Table20 FOREIGN KEY(COL O REFERENCES Tablel(COL 0) GO3. 数据库设计步骤 CREATE TABLE Table1 ( COL_0 VARCHAR ( 20 ) NOT NULL, COL_1 NUMERIC ( 5 ) NOT NULL, CONSTRAINT PK_Table10 PRIMARY KEY NONCLUSTERED (COL_0) ) GO CREATE TABLE Table2 ( COL_2 VARCHAR ( 10 ) NOT NULL, COL_3 VARCHAR ( 20 ) NOT NULL, COL_4 VARCHAR ( 10 ) NOT NULL UNIQUE, COL_0 VARCHAR ( 20 ), CONSTRAINT PK_Table21 PRIMARY KEY NONCLUSTERED (COL_2) ) GO ALTER TABLE Table2 ADD CONSTRAINT FK_Table20 FOREIGN KEY (COL_0) REFERENCES Table1 (COL_0) GO