Oracle 的constraint写法

• 前言
  There are a couple of ways to add constraints to restrict the values in the database. This article is about how to define a foreign key constraint and a check constraint in two ways.
• Table T1

CREATE TABLE T1 (
PID INT PRIMARY KEY, 
SCORE INT, 
ISMINORITY VARCHAR(1)
);

• Table T2
  we are going to define a fk constraint and a check constraint on T2
  
  • the inline way

CREATE TABLE T2 (
PID INT  CONSTRAINT FK_PID REFERENCES T1(PID), 
SCORE INT, 
ISMINORITY VARCHAR(1)  CHECK(ISMINORITY IN ('N','Y'))
);

• the out-of-line way

CREATE TABLE T2 (
PID INT, 
SCORE INT, 
ISMINORITY VARCHAR(1),
CONSTRAINT FK_PID FOREIGN KEY (PID)  REFERENCES T1(PID),
CONSTRAINT CHECK_ISMINORITY CHECK(ISMINORITY IN ('N','Y'))
);