Create Table 형식...

CREATE TABLE team

  (

    team_id     CHAR(3) NOT NULL,

    region_name VARCHAR2(8) NOT NULL,

    team_name   VARCHAR2(40) NOT NULL,

    e_team_name VARCHAR(50),

    orig_YYYY   CHAR(4),

    stadium_id  CHAR(3) NOT NULL,

    zip_code1   CHAR(3),

    zip_code2   CHAR(3),

    address     VARCHAR2(80),

    ddd         VARCHAR2(3),

    tel         VARCHAR2(10),

    fax         VARCHAR2(10),

    homepage    VARCHAR(50),

    owner       VARCHAR(10),

    CONSTRAINT team_pk PRIMARY KEY (team_id),

    CONSTRAINT team_fk FOREIGN KEY(stadium_id) REFERENCES stadium(stadium_id)

  );

제약 조건은 재정의가 가능하지만 테이블을 생성할때 같이 만들어주는 것이 좋다.