createdirector.sql

来自「oracle 9培训基础教程」· SQL 代码 · 共 9 行

CREATE TABLE "SCOTT"."DIRECTOR" (
         "DIRECTOR_ID"    NUMBER(6)        NOT NULL,
         "NAME"           VARCHAR2(10)     NOT NULL,
         "ZHICHENG"       VARCHAR2(20)     NOT NULL,
         "ZHIWU"          VARCHAR2(20)     NOT NULL, 
    CONSTRAINT "导师编号主码" PRIMARY KEY("DIRECTOR_ID") 
    USING INDEX  
    TABLESPACE "USERS")  
    TABLESPACE "USERS"